Tuesday, May 21, 2013

SQL Server Version

November 1, 2009 by · Leave a Comment 

If you need to know the version you are currently running of SQL Server you can easily get it by running the following query.


SELECT ‘ SQL Server ‘ +

CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productversion ‘ )) + ‘ – ‘ +

CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productlevel ‘ )) + ‘ – ‘ +

CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ edition ‘ ))

Top Blogs

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

*