Installing SQL Server
Level 2: Handling Major Changes to Behavior
Backward Compatibility Level 2 consists of important changes in Microsoft® SQL Server™ 2000 that produce different behavior from earlier versions of SQL Server. For example, items in this category are those that have changed behavior in data type conversion or usage of selected functions, changed behavior of clauses in selected Transact-SQL statements and stored procedures, changed column names in selected system tables, and changed behavior due to the database compatibility setting. This topic covers backward compatibility details for these items.
| This subheading | Relates to |
|---|---|
| Backup and Restore | BACKUP CREATE DATABASE ALTER DATABASE RESTORE sp_dboption |
| Bulk Copy | bcp Utility |
| Configuration Options | Setting Configuration Options sp_configure (open objects and user connections options) |
| Database Pages and Extents | Pages and Extents |
| Data Types | CAST and CONVERT Data Types |
| DB-Library | dbcursorfetchex |
| Empty Strings | sp_dbcmptlevel CHARINDEX DATALENGTH LEFT LTRIM PATINDEX REPLICATE RIGHT RTRIM SPACE SUBSTRING UPDATETEXT |
| Indexes | CREATE INDEX |
| INSERT | sp_dbcmptlevel INSERT |
| Keyset Cursors | Keyset cursors |
| LTRIM and RTRIM Trimming Functions | LTRIM RTRIM |
| ODBC | SQLGetDiagRec SQLMoreResults |
| RIGHT | Using Identifiers Reserved Keywords |
| Security | GRANT REVOKE DENY sp_addlinkedsrvlogin |
| SELECT | SELECT |
| SET SHOWPLAN | SET SHOWPLAN_ALL SET SHOWPLAN_TEXT |
| System Tables | Information Schema Views System Stored Procedures (Catalog Procedures) sysdatabases (logptr and dumptrdate columns) sysmessages (langid column) syslogins (language column) computed columns |
| Table Hints | DELETE FROM INSERT SELECT UPDATE |
| Transactions | SET TRANSACTION ISOLATION LEVEL SET CURSOR_CLOSE_ON_COMMIT ROLLBACK DECLARE CURSOR |
| Triggers and System Stored Procedures | sp_dbcmptlevel sp_create_removable CREATE TRIGGER SET QUOTED_IDENTIFIER SET ANSI_NULLS SET ANSI_DEFAULTS |
| UPDATE | @@ERROR UPDATE INSERT |
| UPDATETEXT | UPDATETEXT WRITETEXT |
| Views | DELETE INSERT UPDATE |