Client Management Suite

 View Only

SQL Server Version Query 

Oct 14, 2010 11:45 AM

On occasion I've been asked about version of SQL Server I'm running when calling support. To make it a little easier to tell you can launch SQL Server Management Studio and execute the following query on master:

 

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

 

This should display the full dotted version, servicepack, and version of your SQL installation.

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Oct 18, 2010 09:30 AM

Thank you

very useful

Andrey

Related Entries and Links

No Related Resource entered.