I can find out the version, edition, and build of my SQL Server by using the SERVERPROPERTY function in SQL Server (the full list of options for this function exists at the foot of this post).
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
This will return results such as:
10.0.2531.0 SP1 Enterprise Edition
You can then reference against the build list in Steve Jones' post to see the version you are running
http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/
Full details of all the SERVERPROPERTY options can be found here:
http://msdn.microsoft.com/en-us/library/ms174396.aspx
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
This will return results such as:
10.0.2531.0 SP1 Enterprise Edition
You can then reference against the build list in Steve Jones' post to see the version you are running
http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/
Full details of all the SERVERPROPERTY options can be found here:
http://msdn.microsoft.com/en-us/library/ms174396.aspx
No comments:
Post a Comment