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.



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: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: