Of all the ways, SELECT SERVERPROPERTY('ProductLevel')would be of much use as it tells what SP you are running, which most people want rather than version number.

And there is one more way to find this along with version number is Enterprise Manager.If you right click on the Server (in EM), on the General tab you would see 'product version', which would tell you which service pack and version number you are running.

This is a great article. When Sapphire (SQL Slammer) hit our networking team went to every machine that even had SQLServer.exe (inside service packs or not) and shut them off the network. We had to prove to them we had the latest and greatest. With this tool it is a lot simpler because non-DBA's don't understand 8.00.760 is the latest they know SP3.

Sounds like a great article and tip.... Until you go to try it all out and you find that most of it doesn't work in SQL 7. It would be nice if folks would mention what version they based their work on at the start of the article.