Backward Compatibility Level 1 consists of administrative statements, stored procedures, or Microsoft® SQL Server™ items that were supported in SQL Server 6.5 but have been removed from, or are no longer supported in, SQL Server 2000. Administrative tools or scripts using these items must be fixed prior to using SQL Server 2000.
| This subheading | Relates to |
| Backup and Restore | BACKUP
RESTORE
DUMP
LOAD
sysbackuphistory
sysbackupdetail
sysrestorehistory
sysrestoredetail
backupfile
backupmediafamily
backupmediaset
backupset
restorefile
restorefilegroup
restorehistory |
| Configuration Options | sp_configure (backup buffer size, backup threads, database size, free buffers, hash buckets, LE threshold maximum, LE threshold minimum, LE threshold percent, logwrite sleep, max lazywrite IO, memory, open databases, procedure cache, RA cache hit limit, RA cache miss limit, RA delay, RA pre-fetches, RA slots per thread, RA worker threads, recovery flags, remote conn timeout, SMP concurrency, sort pages, min memory per query, index create memory, tempdb in ram, and user connections options)
trace flag 204 |
| Custom Sort Orders | Character sets, sort orders, and Unicode collations |
| Databases | ALTER DATABASE |
| Database Options | sp_dboption (subscribe and no chkpt. on recovery options)
sp_addsubscription
RESTORE |
| Data Access Objects (DAO) | odbccmpt utility |
| DBCC | DBCC DBREINDEX
DBCC MEMUSAGE
DBCC SHRINKDB |
| DB-Library | Two-Phase Commit
DB-Library for Visual Basic |
| DECnet Network Library | DECnet Sockets Net-Library |
| Disk Commands | DISK REINIT
DISK REFIT
ALTER DATABASE |
| Disk Mirroring | DISK MIRROR
DISK REMIRROR
DISK UNMIRROR |
| Indexes | CREATE INDEX |
| Open Data Services | Windows NT Component Services
SRV_CONFIG
SRV_PROC
SRV_SERVER
srv.h
Opends60.lib |
| Program Group Tools and Utilities | Client Network Utility
ISQL_w
MS Query
SQL Client Configuration
SQL Enterprise Manager
SQL Help
SQL Security Manager
SQL Trace
SQL Performance Monitor
SQL Service Manager
SQL Setup
SQL Query Analyzer
SQL Server Enterprise Manager
SQL Server Profiler
SQL Server Service Manager
|
| Replication | Restricted publications
DBOption object
ReplicationDatabase object EnablePublishing property
repl_publisher login |
| Security | DENY
Delimited Identifiers |
| Segments | CREATE INDEX
CREATE TABLE
sp_addsegment
sp_dropsegment
sp_extendsegment
sp_helpsegment
CREATE DATABASE
ALTER DATABASE |
| Services | SQL Executive |
| SET DISABLE_DEF_CNST_CHK | SET DISABLE_DEF_CNST_CHK |
| SET SHOWPLAN | SET SHOWPLAN
SET SHOWPLAN_ALL
SET SHOWPLAN_TEXT |
| SQL Alerter | SQLALRTR.exe |
| SQL-DMO | sqlole.dll |
| System Stored Procedures (General Extended Procedures) | xp_snmp_getstate
xp_snmp_raisetrap |
| System Stored Procedures (Replication) | sp_replica
sp_replsync
sp_helppublicationsync
sp_subscribe
sp_unsubscribe
@@ERROR
sp_changepublication
sp_addpublisher
sp_adddistpublisher
sp_droppublisher
sp_dropdistpublisher
sp_distcounters
sp_helpreplicationdb
sp_helpreplicationdboption
sp_replstatus |
| System Stored Procedures (System) | ALTER TABLE
CREATE TABLE
sp_help
sp_helpconstraint
sp_commonkey
sp_dropkey
sp_foreignkey
sp_helpjoins
sp_helpkey
sp_primarykey
sp_placeobject
sp_dbinstall
sp_attach_db
sp_makestartup
sp_unmakestartup
sp_procoption
sp_helplogins
sp_helprotect
sp_tableoption
sp_serveroption (fallback option)
sp_setlangalias
sp_droplanguage
sp_fallback_activate_svr_db
sp_fallback_deactivate_svr_db
sp_fallback_enroll_svr_db
sp_fallback_help
sp_fallback_permanent_svr
sp_fallback_upd_dev_drive
sp_fallback_withdraw_svr_db
sp_devoption
sp_diskdefault
sp_helplog
sp_helpstartup
sp_help_revdatabase
sp_sqlexec
sp_addlanguage |
| System Stored Procedures (Tasks) | sp_addalert
sp_addnotification
sp_addoperator
sp_dropalert
sp_dropnotification
sp_dropoperator
sp_helpalert
sp_helphistory
sp_helpnotification
sp_helpoperator
sp_purgehistory
sp_runtask
sp_stoptask
sp_updatealert
sp_updatenotification
sp_updateoperator
sp_add_alert
sp_add_notification
sp_add_operator
sp_delete_alert
sp_delete_notification
sp_delete_operator
sp_help_alert
sp_help_jobhistory
sp_help_notification
sp_help_operator
sp_purge_jobhistory
sp_start_job
sp_stop_job
sp_update_alert
sp_update_notification
sp_update_operator |
| System Tables | Information Schema Views
System Stored Procedures (Catalog Procedures)
sysdevices (mirrorname and stripeset columns)
syshistory
sysjobhistory
sysindexes (distribution, segment, rowpage, keys1, and keys2 columns)
syskeys
syslocks
syslockinfo
syslogs
sysprocesses (gid and suid columns)
sysprocedures
syscomments
syssegments
CREATE DATABASE
ALTER DATABASE
CREATE TABLE
ALTER TABLE
CREATE INDEX
systasks
sysjobs
sysjobsteps
sysjobservers
sysusages
master.dbo.spt_datatype_info |
| Transactions | Data type conversions |
| Utilities | probe login |