Installing SQL Server
Level 3: Updating to Improve Earlier Functionality
Backward Compatibility Level 3 consists of items that were supported in SQL Server version 6.5 but are supported in SQL Server 2000 (and SQL Server 7.0) for backward compatibility only. Any item included in this category is fully supported, but may be removed or unsupported in a future release. It is recommended that, as time allows, the backward compatible item be replaced with the recommended item. SQL Server 2000 provides features that accomplish these tasks more efficiently and have ongoing support.
This topic covers backward compatibility details for these items.
| This subheading | Relates to |
|---|---|
| Backup and Restore | BACKUP RESTORE CREATE DATABASE |
| Database Options | sp_dboption (publish option) sp_replicationdboption |
| DBCC | DBCC NEWALLOC DBCC CHECKALLOC DBCC ROWLOCK Architecture Enhancements DBCC TEXTALL DBCC CHECKDB DBCC TEXTALLOC DBCC CHECKTABLE DBCC DBREPAIR DROP DATABASE |
| Devices | Overview of SQL Server Architecture DISK INIT CREATE DATABASE ALTER DATABASE DISK REINIT sp_logdevice sp_dropdevice |
| Open Data Services | srv_config srv_config_alloc srv_getconfig srv_init srv_run srv_tdsversion srv_getuserdata srv_setuserdata srv_errhandle srv_iodead srv_log srv_sendstatus srv_sfield srv_event srv_eventdata srv_getserver srv_got_attention srv_handle srv_pre_handle srv_post_handle srv_setevent srv_terminatethread srv_attention srv_connect srv_disconnect srv_language srv_rpc srv_exit srv_start srv_sleep srv_restart srv_stop srv_langcpy srv_langlen srv_langptr srv_paramdata srv_paramlen srv_parammaxlen srv_paramname srv_paramnnumber srv_paramset srv_paramstatus srv_paramtype srv_returnval srv_rpcdb srv_rpcnumber srv_rpcoptions srv_clearstatistics srv_sendstatistics srv_alloc srv_bmove srv_bzero srv_free srv.h srv_describe srv_setcollen srv_setcoldata srv_paramsetoutput srv_paraminfo |
| Query Performance | SUSER_ID SUSER_SID SUSER_NAME SUSER_SNAME syslogins sysdatabases sysremotelogins sysusers sysalternates |
| Security | GRANT Authentication SETUSER |
| SELECT | FASTFIRSTROW SELECT INDEX = (index hint) |
| SET SHOWPLAN | SET SHOWPLAN_TEXT SET SHOWPLAN_ALL SQLGetDiagRec |
| System Stored Procedures (Extended) | xp_grantlogin xp_revokelogin sp_grantlogin sp_revokelogin |
| System Stored Procedures (System) | sp_add_job sp_add_jobschedule sp_add_jobstep sp_addtask sp_delete_job sp_delete_jobschedule sp_delete_jobstep sp_droptask sp_help_jobhistory sp_help_jobschedule sp_help_jobstep sp_helptask sp_purge_jobhistory sp_reassigntask sp_start_job sp_stop_job sp_update_job sp_update_jobschedule sp_update_jobstep sp_updatetask |