How to verify your SQL Server Version

I had a query today from auditors that needed a SQL server’s version details and for some reason using help=>about does not show if it’s the Standard or Enterprise version.

To get this info open your SQL Management Studio, click on new query, in the query field type “select @@version” without the quotation marks, then click execute.
This will show you the SQL version details as per below screen shot.

 

Advertisements

About Tiens van Zyl

I am a Microsoft Exchange Engineer for a local IT Outsource company assisting with 3rd line support to our Enterprise clients and Hosted Exchange Service. I'm a passionate gamer and also a very active musician. View all posts by Tiens van Zyl

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: