How to determine which version of SQL Server is running using T-SQL

Question

I need help using T-SQL to figure-out the version of SQL Server running and execute different code sets based on weather SQL Server 2000 or Sql Server 2008 is running.

gbn · Accepted Answer · 2011-02-28 19:34:09Z

7

SELECT @@VERSION?

Or one of the SERVERPROPERTY options?

answered Feb 28, 2011 at 19:34

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pero P. · Accepted Answer · 2011-02-28 19:33:59Z

6

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

answered Feb 28, 2011 at 19:33

Pero P.

27.1k9 gold badges65 silver badges87 bronze badges

Comments

Oded · Accepted Answer · 2011-02-28 19:38:44Z

6

Just query the database - there is a @@VERSION property:

SELECT @@VERSION

Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

As mentioned on the page, since all of this data is returned in one varchar, you can use the SERVERPROPERTY function to retrieve only the version:

SELECT SERVERPROPERTY('ProductVersion')

edited Feb 28, 2011 at 19:38

answered Feb 28, 2011 at 19:33

Oded

501k102 gold badges900 silver badges1k bronze badges

1 Comment

Joe Stefanelli Over a year ago

That's an ugly string to deal with programatically.

RichardTheKiwi · Accepted Answer · 2011-02-28 19:42:51Z

5

@@VERSION / SERVERPROPERTY

But you should also check

exec sp_dbcmptlevel 'dbname'

To ensure a certain feature works at the database's compatibility level.

answered Feb 28, 2011 at 19:42

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

1 Comment

gbn Over a year ago

Good thinking about sp_dbcmptlevel. This matters more in some cases

Joe Stefanelli · Accepted Answer · 2011-02-28 19:34:02Z

1

SELECT SERVERPROPERTY('productversion')

The digits before the first period will give you the major version: 10 = 2008, 9 = 2005, 8 = 2000.

answered Feb 28, 2011 at 19:34

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Comments

PedroC88 · Accepted Answer · 2011-02-28 19:35:24Z

1

Use to get the server SQL version:

SELECT SERVERPROPERTY('ProductVersion')
GO

Or for a more verbose command

SELECT @@VERSION
GO

Also in here you can find a list of the releases's version numbers

answered Feb 28, 2011 at 19:35

PedroC88

3,8688 gold badges49 silver badges86 bronze badges

Comments

SaDHacK · Accepted Answer · 2014-10-01 20:09:29Z

0

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

answered Oct 1, 2014 at 20:09

SaDHacK

891 silver badge7 bronze badges

Comments

Rakesh Reddy · Accepted Answer · 2014-12-23 06:42:24Z

0

EXEC[MASTER].SYS.[XP_MSVER]--To  get  the  server version

edited Dec 23, 2014 at 6:42

answered Dec 23, 2014 at 6:12

Rakesh Reddy

11 bronze badge

Collectives™ on Stack Overflow

How to determine which version of SQL Server is running using T-SQL

8 Answers 8

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related