Ramblings about MS Dynamics CRM 2011 and coding basics.

Friday, March 21, 2008

Determing the SQL Server 2005 version and SP

Hello,

I find that I need to figure out what version of SQL build and SP is applied to a client's SQL Server. For 2005, running either of these two queries is extremely helpful:
SELECT @@Version
or
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I found excellent information on this Microsoft page:
http://support.microsoft.com/kb/321185

In general, I have been looking to see if the build is: 9.00.3054 or 9.00.3159 to figure out if the installation is SQL Server 2005 with SP2.

Thanks,
Mark

Labels: , ,

0 Comments:

Post a Comment

<< Home