Use Level0type = 'USER' only to add an extended property directly to a user or role.

Use Level0type = 'SCHEMA' to add an extended property to level-1 types like TABLE or VIEW, or level-2 types like COLUMN or TRIGGER. For more information, see sp_addextendedproperty (Transact-SQL).

Extended stored procedure programming

srv_alloc

srv_convert

srv_describe

srv_getbindtoken

srv_got_attention

srv_message_handler

srv_paramdata

srv_paraminfo

srv_paramlen

srv_parammaxlen

srv_paramname

srv_paramnumber

srv_paramset

srv_paramsetoutput

srv_paramtype

srv_pfield

srv_pfieldex

srv_rpcdb

srv_rpcname

srv_rpcnumber

srv_rpcoptions

srv_rpcowner

srv_rpcparams

srv_senddone

srv_sendmsg

srv_sendrow

srv_setcoldata

srv_setcollen

srv_setutype

srv_willconvert

srv_wsendmsg

Use CLR Integration instead.

Extended stored procedure programming

sp_addextendedproc

sp_dropextendedproc

sp_helpextendedproc

Use CLR Integration instead.

Extended stored procedures

xp_LoginConfig

IsIntegratedSecurityOnly argument of SERVERPROPERTY

Full-text search

sp_fulltext_catalog

CREATE/ALTER/DROP FULLTEXT CATALOG

Full-text search

sp_fulltext_table

sp_fulltext_column

sp_fulltext_database

CREATE/ALTER/DROP FULLTEXT INDEX

ALTER FULLTEXT INDEX

Full-text search

sp_help_fulltext_tables[_cursor]

sp_help_fulltext_columns[_cursor]

sp_help_fulltext_catalogs[_cursor]

sys.fulltext_indexes

sys.fulltext_index_columns

sys.fulltext_catalogs

Functions

fn_get_sql

sys.dm_exec_sql_text

Index options

sp_indexoption

fillfactor = 0

ALTER INDEX

fillfactor = 100

Index options

CREATE INDEX <index_option>::= syntax

CREATE INDEX <relational_index_option>::= syntax

Instance options

Default setting of disallow results from triggers option = 0

Default setting of disallow results from triggers option = 1

Locking

sp_lock

sys.syslock_information

Locking

syslockinfo

sys.syslock_information

Metadata

DATABASEPROPERTY

FILE_ID

INDEXKEY_PROPERTY

DATABASEPROPERTYEX

FILE_IDEX

sys.index_columns

Other

DB-Library

Embedded SQL for C

Although the SQL Server 2005 Database Engine still supports connections from existing applications using the DB-Library and Embedded SQL APIs, it does not include the files or documentation needed to do programming work on applications that use these APIs. A future version of the SQL Server Database Engine will drop support for connections from DB-Library or Embedded SQL applications. Do not use DB-Library or Embedded SQL to develop new applications. Remove any dependencies on either DB-Library or Embedded SQL when modifying existing applications. Instead of these APIs, use the SQLClient namespace or an API such as OLE DB or ODBC. SQL Server 2005 does not include the DB-Library DLL required to run these applications. To run DB-Library or Embedded SQL applications you must have available the DB-Library DLL from SQL Server version 6.5, SQL Server 7.0, or SQL Server 2000.

Query hints

FASTFIRSTROW hint

OPTION (FAST n).

Removable databases

sp_certify_removable

sp_create_removable

sp_detach_db

Removable databases

sp_dbremove

DROP DATABASE

Security

sp_addapprole

sp_dropapprole

CREATE APPLICATION ROLE

DROP APPLICATION ROLE

Security

sp_addlogin

sp_droplogin

CREATE LOGIN

DROP LOGIN

Security

sp_adduser

sp_dropuser

CREATE USER

DROP USER

Security

sp_grantdbaccess

sp_revokedbaccess

CREATE USER

DROP USER

Security

sp_addrole

sp_droprole

CREATE ROLE

DROP ROLE

Security

sp_approlepassword

sp_password

ALTER APPLICATION ROLE

ALTER LOGIN

Security

sp_changeobjectowner

ALTER SCHEMA or ALTER AUTHORIZATION

Security

sp_defaultdb

sp_defaultlanguage

ALTER LOGIN

Security

sp_denylogin

sp_grantlogin

sp_revokelogin

ALTER LOGIN DISABLE

CREATE LOGIN

DROP LOGIN

Security

USER_ID

FILE_ID

DATABASE_PRINCIPAL_ID

FILE_IDEX

Security

sp_srvrolepermission

sp_dbfixedrolepermission

These stored procedures return information that was correct in SQL Server 2000. The output does not reflect changes to the permissions hierarchy implemented in SQL Server 2005. For more information, see "Permissions of Fixed Roles" in SQL Server 2005 Books Online.

The compatibility views do not expose metadata for features introduced in SQL Server 2005. It is recommended that you upgrade your applications to use catalog views. For more information, see Catalog Views (Transact-SQL).

Table hints

Specifying NOLOCK or READUNCOMMITTED in the FROM clause of an UPDATE or DELETE statement when applied to the target table of the statement.

Remove the NOLOCK or READUNCOMMITTED table hints from the FROM clause.