Level 3: Updating to Improve Earlier Functionality

Installing SQL Server

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