Database options

option.

Deprecated feature

Replacement

Feature name

statement with the

option. To rebuild multiple log

files, when one or more have a new location, use the

option.

sp_renamedb

Deprecated feature

Replacement

Feature name

sp_unbindefault

keyword in

and

CREATE_DROP_DEFAULT

sp_bindrule

keyword in

and

CREATE_DROP_RULE

Use.

and

Use MARS or distributed transactions.

Deprecated feature

Replacement

Feature name

Use MARS or distributed transactions.

{

}

sp_resetstatus

option of

ﾉ

Expand table

ﾉ

Expand table

ﾉ

Expand table

sp_attach_db sp_attach_single_file_db
CREATE DATABASE

FOR ATTACH

FOR ATTACH_REBUILD_LOG

sp_attach_db sp_attach_single_file_db sp_certify_removable sp_create_removable sp_detach_db sp_certify_removable sp_create_removable sp_dbremove
DROP DATABASE sp_dbremove sp_renamedb
MODIFY NAME

ALTER DATABASE

CREATE DEFAULT
DROP DEFAULT sp_bindefault

DEFAULT

CREATE TABLE

ALTER TABLE

sp_bindefault sp_unbindefault
CREATE RULE
DROP RULE

sp_unbindrule
CHECK

CREATE TABLE

ALTER TABLE

sp_bindrule sp_unbindrule sp_change_users_login

ALTER USER

sp_change_users_login sp_depends sys.dm_sql_referencing_entities

sys.dm_sql_referenced_entities sp_depends sp_getbindtoken

sp_getbindtoken

sp_bindsession

sp_bindsession sp_resetstatus
ALTER DATABASE SET

ONLINE

EMERGENCY

TORN_PAGE_DETECTION

ALTER
DATABASE
PAGE_VERIFY TORN_PAGE_DETECTION

ALTER
DATABASE
ALTER DATABASE WITH
TORN_PAGE_DETECTION