Search

Thursday, July 28, 2011

List compatibility info for every database in an instance

Even if the database is hosted in an sql 2005 instance it will not be able to use the features and tables/views of sql 2005 if it is on level 2000. To list the databases with less than sql 20005 level I use this code:

use master
SELECT name,cmptlevel FROM sysdatabases where cmptlevel<90

No comments:

Post a Comment