System Stored Procedures (System) (Level 1)

System Stored Procedures (System) (Level 1)

  New Information - SQL Server 2000 SP3.

SQL Server 6.x SQL Server 2000
Several system stored procedures were used for documenting keys. Removed; no longer supported or available. Use declarative referential integrity by implementing keys and constraints with either ALTER TABLE or CREATE TABLE. Remove all references to these system stored procedures and replace with references to either sp_help or sp_helpconstraint:

sp_commonkey
sp_dropkey
sp_foreignkey
sp_helpjoins
sp_helpkey
sp_primarykey

sp_placeobject put future space allocations for a table or index on a particular segment. sp_placeobject is no longer available because segments no longer exist. Use the ON FILEGROUP syntax of the CREATE TABLE statement to place table or index information about a separate filegroup. Remove all references of sp_placeobject and replace with references to the ON FILEGROUP clause of the CREATE TABLE statement.
sp_dbinstall installed a database and its devices, and was used for removable media. Removed; no longer supported or available. Remove all references to sp_dbinstall and replace with references to sp_attach_db.
sp_makestartup and sp_unmakestartup set a stored procedure for auto execution and discontinued auto execution of the stored procedure, respectively. Removed; no longer supported or available. Remove all references of either sp_makestartup or sp_unmakestartup and replace with references to sp_procoption.
The sp_helplogins, sp_helprotect, and sp_tableoption system stored procedures supported pattern matching (using wildcard characters), which allowed flexibility in specific parameters. Pattern matching using the wildcard characters is no longer supported in these system stored procedures because any system stored procedure identifier may contain a pattern matching character. Remove all references to pattern matching in sp_helplogins, sp_helprotect, and sp_tableoption.
The fallback option of sp_serveroption indicated a fallback server. The fallback option of sp_serveroption is no longer available because the fallback option is no longer supported. Remove all references to the fallback option of sp_serveroption.
sp_setlangalias assigned or changed the alias for an alternate language. Removed; no longer supported. Use the aliases provided in syslanguages. Remove all references to sp_setlangalias.
sp_droplanguage dropped an alternate language from the server and removed its row from master.dbo.syslogins. Removed; no longer supported. Remove all references to sp_droplanguage.
Fallback support was provided by executing system stored procedures that shifted control of databases and devices from a broken primary server to a fallback server. Fallback support is no longer supported using the fallback system stored procedures. Support for fallback servers is supported using Microsoft Windows NT Clustering Service. Remove all references to these fallback system stored procedures:

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 displayed or set device status. Removed; no longer available. Remove all references to sp_devoption.
sp_diskdefault set a database device status to indicate whether the device can be used for database storage when the user does not specify a database device or specifies DEFAULT with the CREATE DATABASE or ALTER DATABASE statements. Removed; no longer available. Remove all references to sp_diskdefault.
sp_helplog reported the name of the device that contains the first page of the log in the current database. Removed; no longer available. Remove all references to sp_helplog.
sp_helpstartup reported a listing of all auto-start stored procedures. Removed; no longer available. Remove all references to sp_helpstartup and replace with references to sp_procoption.
sp_sqlexec provided a convenient way for SQL Server database clients and servers to send a language statement of any format to an Open Data Services server application. Removed; no longer available. Remove all references to sp_sqlexec.
sp_help_revdatabase analyzed an existing database and created a script that could be used to replicate the database structure on another server. Removed; no longer available. If applicable, use the SQL-DMO Script Method of the Database Object to generate similar information. Remove all references to sp_help_revdatabase.
sp_addlanguage added an alternate language to a server. Removed; no longer available. Remove all references to sp_addlanguage.

Show: