Internal Database Version

[Denden]

hello, do you know how to determine the database version of a database on sql server management studio for some compatibility reasons because not all of the databases are created using the version of sql server i am currently running. some of them are attached using backup. Thanks.

[ck9663]

This this:

SELECT DatabaseProperty ('YourDatabaseName', 'version');

Then check this table out.

Good Luck!!!


~~ CK

[Denden]

Thanks for the reply CK but the query gave me a null value.
I tried this query.

SELECT DatabaseProperty ('TestDB', '660');
SELECT DatabaseProperty ('TestDB', 660);

and gave me an error.


i also tried

SELECT DatabaseProperty ('TestDB', 'version');

and return 728 version but that database was created using earlier version.

[ck9663]

What version is your server and what version are you expecting your database be?


~~ CK

[Denden]

My server version is 12.0.2 and i tried to created a testDB on sql server 10.50.400 so i am expecting the database version to be 660/661. Thanks for helping me.

[ck9663]

I am not sure if the SSMS you use has any affect on the db you created. BOL however says that function is not reliable. They did not offer any other option :)

~~ CK