Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Compatibility Level of a database

Jan 5 2009 12:45PM by Madhivanan   

When users migrate from SQL Server 2000 to SQL Server 2005, not all databases are set to Compatibility Level 90 which is required to make use of the newly available functions

There are many methods to know the Compatibility Level of a database using queries
--Method 1
EXEC sp_dbcmptlevel your_database_name

--Method 2
EXEC sp_helpdb your_database_name

--Method 3
SELECT name,cmptlevel
FROM master..sysdatabases
WHERE name='your_database_name'


--Method 4
SELECT name,compatibility_level
FROM sys.databases
WHERE name='your_database_name'

Also read

http://beyondrelational.com/blogs/madhivanan/archive/2008/08/12/common-migration-issues-version-2000-to-2005.aspx

Tags: t-sql, sql_server, compatibility_level,


Madhivanan
3 · 40% · 12936
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]