Installing SQL Server
Level 1: Handling Discontinued Functionality
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 |