New way to get SQL Server 2005 version

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.

Transact SQL changed from earlier version

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.

1 May 2006  Comments [0]  SQL Server 2005