After updating my SQL Server 2005 to SP1 I tried to find out what version was running. So I open a new query window and type:
SELECT @@VERSION
and get as result:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) ...
I'm not so good at deciphering these version numbers so I wanted to look them up. Only then I found out that there were some changes to Transact-SQL.
The "new and improved" way to determine your SQL Server 2005 version number is:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
and the result in my case:
9.00.2047.00 SP1 Developer Edition
If you want more information on the properties of your server instance search for "SERVERPROPERTY (Transact-SQL)" in your books online.
The content of this site are my own personal opinions and do not represent my employer's view in anyway. In addition, my thoughts and opinions often change, and as a weblog is intended to provide a semi-permanent point in time snapshot you should not consider out of date posts to reflect my current thoughts and opinions.