How to find out db version? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to find out db version?

Author

Topic

rami99
Starting Member

2 Posts

Posted - 2009-06-11 : 13:20:59

Hello, I need to know how can I view the version of a database. Can someone help me please? I'm a new SQL user.

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-11 : 13:24:07

SELECT @@VERSION

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-11 : 13:24:44

also see

http://support.microsoft.com/kb/321185

rami99
Starting Member

2 Posts

Posted - 2009-06-11 : 13:44:08

Thanks, but this just gives me the version of SQL server but not the version of a particular sql database.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-11 : 13:46:20

what do you mean by version of db? did you mean compatibility level? if yes, use below

EXEC sp_dbcmptlevel 'yourdbname'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources