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