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: SQL, SQL Server 2005, version
0 Comments:
Post a Comment
<< Home