Language Reference: New and Updated Topics (14 April 2006)

New: 14 April 2006

In the 14 April 2006 release of SQL Server Books Online, the following topics have either been added to Books Online or have had significant changes.

Topic Categories

New Reference Topics

Updated Reference Topics

New Reference Topics

DecryptByKeyAutoAsymKey (Transact-SQL)

DecryptByKeyAutoCert (Transact-SQL)

sp_add_jobschedule (Transact-SQL)

sp_dbmmonitoraddmonitoring (Transact-SQL)

sp_dbmmonitorchangealert (Transact-SQL)

sp_dbmmonitorchangemonitoring (Transact-SQL)

sp_dbmmonitordropalert (Transact-SQL)

sp_dbmmonitordropmonitoring (Transact-SQL)

sp_dbmmonitorhelpalert (Transact-SQL)

sp_dbmmonitorhelpmonitoring (Transact-SQL)

sp_dbmmonitorresults (Transact-SQL)

sp_dbmmonitorupdate (Transact-SQL)

sp_unsetapprole (Transact-SQL)

sys.dm_exec_cached_plan_dependent_objects

sys.dm_exec_query_memory_grants

sys.dm_exec_query_resource_semaphores

sys.dm_exec_xml_handles

sys.fn_translate_permissions (Transact-SQL)

sys.openkeys (Transact-SQL)

sys.securable_classes (Transact-SQL)

Arrow icon used with Back to Top linkBack to Top

Updated Reference Topics

@@DATEFIRST (Transact-SQL)

ALTER DATABASE (Transact-SQL)

ALTER TABLE (Transact-SQL)

BACKUP (Transact-SQL)

BETWEEN (Transact-SQL)

BULK INSERT (Transact-SQL)

CASE (Transact-SQL)

CAST and CONVERT (Transact-SQL)

CHECKSUM (Transact-SQL)

column_constraint (Transact-SQL)

COLUMNS_UPDATED (Transact-SQL)

computed_column_definition (Transact-SQL)

CONTAINS (Transact-SQL)

CREATE FUNCTION (Transact-SQL)

CREATE INDEX (Transact-SQL)

CREATE TABLE (Transact-SQL)

CREATE TRIGGER (Transact-SQL)

CREATE TYPE (Transact-SQL)

CREATE VIEW (Transact-SQL)

DATABASEPROPERTYEX (Transact-SQL)

DATEADD (Transact-SQL)

DBCC CHECKALLOC (Transact-SQL)

DBCC CHECKDB (Transact-SQL)

DBCC CHECKFILEGROUP (Transact-SQL)

DBCC CHECKIDENT (Transact-SQL)

DBCC CHECKTABLE (Transact-SQL)

DBCC CLEANTABLE (Transact-SQL)

DBCC INDEXDEFRAG (Transact-SQL)

DBCC SHRINKDATABASE (Transact-SQL)

DBCC SHRINKFILE (Transact-SQL)

DELETE (Transact-SQL)

DROP TYPE (Transact-SQL)

EncryptByAsymKey (Transact-SQL)

EXECUTE (Transact-SQL)

FREETEXT (Transact-SQL)

IDENT_CURRENT (Transact-SQL)

int, bigint, smallint, and tinyint (Transact-SQL)

ISNUMERIC (Transact-SQL)

KILL (Transact-SQL)

NEWSEQUENTIALID()

NSNotificationBatchDetails (Transact-SQL)

NULLIF (Transact-SQL)

OBJECT_ID (Transact-SQL)

OPENDATASOURCE (Transact-SQL)

OPENQUERY (Transact-SQL)

OR (Transact-SQL)

ORDER BY Clause (Transact-SQL)

POWER (Transact-SQL)

RECONFIGURE (Transact-SQL)

Replication Stored Procedures (Transact-SQL)

RESTORE (Transact-SQL)

RESTORE Arguments (Transact-SQL)

SELECT Examples (Transact-SQL)

SERVERPROPERTY (Transact-SQL)

SESSIONPROPERTY (Transact-SQL)

SET ARITHABORT (Transact-SQL)

SET QUERY_GOVERNOR_COST_LIMIT (Transact-SQL)

SET TRANSACTION ISOLATION LEVEL (Transact-SQL)

sp_add_jobstep (Transact-SQL)

sp_add_schedule (Transact-SQL)

sp_addarticle (Transact-SQL)

sp_addmergearticle (Transact-SQL)

sp_changearticle (Transact-SQL)

sp_changemergearticle (Transact-SQL)

sp_databases (Transact-SQL)

sp_dbcmptlevel (Transact-SQL)

sp_detach_db (Transact-SQL)

sp_dropserver (Transact-SQL)

sp_help_fulltext_system_components (Transact-SQL)

sp_helpconstraint (Transact-SQL)

sp_lock (Transact-SQL)

sp_notify_operator (Transact-SQL)

sp_refreshview (Transact-SQL)

sp_special_columns (Transact-SQL)

sp_testlinkedserver (Transact-SQL)

sp_who (Transact-SQL)

sp_xml_preparedocument (Transact-SQL)

sys.all_columns (Transact-SQL)

sys.all_parameters (Transact-SQL)

sys.column_type_usages

sys.columns (Transact-SQL)

sys.database_mirroring (Transact-SQL)

sys.dm_broker_queue_monitors

sys.dm_clr_properties

sys.dm_db_index_operational_stats

sys.dm_db_index_physical_stats

sys.dm_exec_connections

sys.dm_exec_sql_text

sys.dm_os_hosts

sys.dm_os_schedulers

sys.dm_os_tasks

sys.dm_os_wait_stats

sys.dm_os_workers

sys.fulltext_languages (Transact-SQL)

sys.master_files (Transact-SQL)

sys.parameter_type_usages

sys.parameters (Transact-SQL)

sys.servers (Transact-SQL)

sys.syscacheobjects (Transact-SQL)

sys.sysobjects (Transact-SQL)

sys.sysprocesses (Transact-SQL)

sys.system_columns (Transact-SQL)

sys.system_parameters (Transact-SQL)

sys.systypes (Transact-SQL)

sys.type_assembly_usages

sys.types (Transact-SQL)

sysarticles (Transact-SQL)

sysmail_delete_mailitems_sp (Transact-SQL)

sysmail_help_principalprofile_sp (Transact-SQL)

Table Hint (Transact-SQL)

table_constraint (Transact-SQL)

Trace Flags (Transact-SQL)

TRY...CATCH (Transact-SQL)

WHILE (Transact-SQL)

XACT_STATE (Transact-SQL)

Arrow icon used with Back to Top linkBack to Top