Compatibility Mode 90
SQL must be in Compatibility Mode 90 (SQL 2005) or greater to support .NET Assemblies.
sp_dbcmptlevel 'ksubscribers'
- Running this stored procedure displays the compatibility level. sp_dbcmptlevel 'ksubscribers', 90
- Running this stored procedure sets the compatibility level to SQL 2005. If you are using SQL Server 2008, do not run this stored procedure. Collation
master
database.dbtemp
database.ksubscribers
database.SQL_Latin1_General_CP1_CI_AS
Korean_Wansung_CI_AS
Chinese_PRC_CI_AS,
Traditional Chinese can be either: Chinese_Taiwan_Stroke_CI_AS
(more common) or Chinese_Hong_Kong_Stroke_90_CI_AS
Japanese_CI_AS
Note: Changing the collation for SQL Server after it is installed requires expertise. If the collation for the SQL Server must be changed after SQL Server is installed, Kaseya recommends uninstalling SQL Server entirely, then reinstalling SQL Server and selecting the correct language to make the change.
Note: If changing the collation of the ksubscribers
database is required, you can set the collation to match the collation used by the SQL Server database. Uninstalling and reinstalling SQL Server is not required.