How can I find out what SQL Server version is running? — Parv The IT Geek

I was asked by someone which SQL Server version a server was running and was surprised when my DBA colleague said to run a stored procedure I had never heard of. I had not thought that there would be more than one way as the usual method I used below was so simple I didn’t think that there would be a need for another method. I then did a deep dive of all the different ways I could find out the version of SQL Server I was running and have included them below.

Method 1

Go to Help > About

Method 2

Use the following script .

SELECT @@VERSION

That is the script which I would use and I think is pretty much the most commonly used method within the SQL Server community.

Method 3

EXEC sp_MSgetversion

Method 4

EXEC xp_msver

Method 5

SELECT SERVERPROPERTY(‘productversion’),

SERVERPROPERTY (‘productlevel’),

SERVERPROPERTY (‘edition’)

Method 6

Within the SQL logs the current version will be listed when the log was last cycled.


Originally published at https://parvtheitgeek.com on January 13, 2014.

Published by Parvinder Nijjar

I blog at ParvTheITGeek.com

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 )

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: