Setting the MS-SQL compatibility levels

sp_dbcmptlevel : This command is using to set certain database behaviors to be compatible with the specified version of SQL Servers. Example:    —-SQL Server 2005 database compatible level to SQL Server 2000 EXEC sp_dbcmptlevel <DBNAME>, 80; GO Version of SQL Server database can be one of the following: 60 = SQL Server 6.0 65Continue reading “Setting the MS-SQL compatibility levels”

Design a site like this with WordPress.com
Get started