Installing SQL Server
Level 4: Handling Minor Changes to Behavior
Backward Compatibility Level 4 consists of minor changes in Microsoft® SQL Server™ 2000 that produce different behavior from earlier versions of SQL Server. For example, items in this level are either ignored or have one or more ignored parameters, changes to byte lengths, added parameters or columns, or changed data type columns.
This topic covers backward compatibility details for these items.
| This subheading | Relates to these items |
|---|---|
| Aliases | Roles Managing Permissions |
| Backup and Restore | RESTORE HEADERONLY LOAD HEADERONLY |
| Configuration | sp_configure (media retention option) Setting Configuration Options |
| CREATE PROCEDURE | CREATE TABLE SELECT INTO |
| Data Types | decimal and numeric Using Mathematical Functions + (Add) - (Subtract) * (Multiply) / (Divide) ATN2 AVG CAST and CONVERT EXP POWER RADIANS ROUND SUM |
| DATEPART and SET DATEFIRST | SET DATEFIRST DATEPART |
| DBCC | DBCC |
| DBCS String Comparisons | Unicode space characters |
| DELETE and SELECT | FROM |
| Devices | ALTER DATABASE |
| Functions | @@DBTS |
| Global Variables | Functions |
| ODBC | SQL_COPT_SS_PERF_QUERY_INTERVAL SQLMoreResults SQL_NO_DATA |
| Rebuilding the master Database | Rebuild Master Utility |
| Rebuilding the Registry (Level 4) | setup/t RegistryRebuild = On |
| Replication | Replication Between Different Versions of SQL Server Subscribing to One or More Articles of a Publication |
| Security | SYSTEM_USER |
| SELECT | SELECT FROM |
| Triggers and System Stored Procedures (System) | CREATE TRIGGER sp_dboption (recursive triggers option) sp_tableoption xp_readmail xp_sendamil |
| UPDATE | UPDATE |
| Utilities | SQL Query Analyzer isql utility |