Level 2: Handling Major Changes to Behavior

Installing SQL Server

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