Language Reference: New and Updated Topics (1 February 2007)

  • Article

In the 12 December 2006 release of SQL Server Books Online, the following topics have either been added or updated.

Topic Categories

Updated Conceptual and Task Topics

New Reference Topics

Updated Reference Topics

Updated Conceptual and Task Topics

Multidimensional Expressions (MDX)

Intrinsic Member Properties (MDX)

Transact-SQL

Catalog Views (Transact-SQL)

Execution Related Dynamic Management Views and Functions

MSpublications (Transact-SQL)

RESTORE Arguments (Transact-SQL)

sys.dm_clr_appdomains

sys.dm_clr_loaded_assemblies

sys.dm_clr_properties

sys.dm_exec_background_job_queue_stats

sys.dm_exec_background_job_queue

sys.dm_exec_cached_plans

sys.dm_exec_connections

sys.dm_exec_query_optimizer_info

sys.dm_exec_query_stats

sys.dm_exec_requests

sys.dm_exec_sessions

sys.dm_fts_index_population

sys.dm_fts_memory_buffers

sys.dm_fts_memory_pools

sys.dm_fts_population_ranges

sys.dm_qn_subscriptions

sys.login_token (Transact-SQL)

sys.sql_dependencies (Transact-SQL)

sys.user_token (Transact-SQL)

sysmergepublications (Transact-SQL)

syspublications (System View) (Transact-SQL)

syspublications (Transact-SQL)

Arrow icon used with Back to Top linkBack to Top

New Reference Topics

OBJECT_SCHEMA_NAME (Transact-SQL)

sp_db_vardecimal_storage_format (Transact-SQL)

sp_estimated_rowsize_reduction_for_vardecimal (Transact-SQL)

sp_refreshsqlmodule (Transact-SQL)

sp_vupgrade_mergeobjects (Transact-SQL)

sys.dm_exec_text_query_plan

Arrow icon used with Back to Top linkBack to Top

Updated Reference Topics

Multidimensional Expressions (MDX)

Avg (MDX)

CASE Statement (MDX)

CREATE GLOBAL CUBE Statement (MDX)

CREATE MEMBER Statement (MDX)

CREATE SESSION CUBE Statement (MDX)

Exists (MDX)

Max (MDX)

Median (MDX)

Min (MDX)

Ordinal (MDX)

Properties (MDX)

Rank (MDX)

Sum (MDX)

Arrow icon used with Back to Top linkBack to Top

Transact-SQL

@@IDENTITY (Transact-SQL)

ALTER ASYMMETRIC KEY (Transact-SQL)

ALTER CERTIFICATE (Transact-SQL)

ALTER DATABASE (Transact-SQL)

ALTER FULLTEXT INDEX (Transact-SQL)

ALTER LOGIN (Transact-SQL)

ALTER TABLE (Transact-SQL)

ALTER TRIGGER (Transact-SQL)

BACKUP (Transact-SQL)

BULK INSERT (Transact-SQL)

column_constraint (Transact-SQL)

computed_column_definition (Transact-SQL)

CREATE DATABASE (Transact-SQL)

CREATE FULLTEXT INDEX (Transact-SQL)

CREATE PROCEDURE (Transact-SQL)

CREATE TABLE (Transact-SQL)

DBCC CHECKDB (Transact-SQL)

DBCC CHECKFILEGROUP (Transact-SQL)

DBCC CHECKTABLE (Transact-SQL)

DBCC FREEPROCCACHE (Transact-SQL)

DBCC FREESYSTEMCACHE

DENY (Transact-SQL)

DISABLE TRIGGER (Transact-SQL)

DROP DATABASE (Transact-SQL)

DROP TABLE (Transact-SQL)

ENABLE TRIGGER (Transact-SQL)

EVENTDATA (Transact-SQL)

fn_my_permissions (Transact-SQL)

GRANT (Transact-SQL)

ISNUMERIC (Transact-SQL)

NULLIF (Transact-SQL)

OBJECT_NAME (Transact-SQL)

OBJECTPROPERTY (Transact-SQL)

OBJECTPROPERTYEX (Transact-SQL)

OPENROWSET (Transact-SQL)

OUTPUT Clause (Transact-SQL)

RESTORE (Transact-SQL)

SCOPE_IDENTITY (Transact-SQL)

sp_add_schedule (Transact-SQL)

sp_addlinkedserver (Transact-SQL)

sp_addmergepublication (Transact-SQL)

sp_addmergepullsubscription (Transact-SQL)

sp_addmergepullsubscription_agent (Transact-SQL)

sp_addmergepushsubscription_agent (Transact-SQL)

sp_addpublication (Transact-SQL)

sp_addpublication_snapshot (Transact-SQL)

sp_addpullsubscription (Transact-SQL)

sp_addpullsubscription_agent (Transact-SQL)

sp_addpushsubscription_agent (Transact-SQL)

sp_attach_db (Transact-SQL)

sp_change_users_login (Transact-SQL)

sp_changemergepublication (Transact-SQL)

sp_changepublication (Transact-SQL)

sp_changepublication_snapshot (Transact-SQL)

sp_detach_db (Transact-SQL)

sp_helpmergepublication (Transact-SQL)

sp_serveroption (Transact-SQL)

sp_settriggerorder (Transact-SQL)

sp_tableoption (Transact-SQL)

sp_tables (Transact-SQL)

sp_trace_setevent (Transact-SQL)

sys.dm_db_missing_index_columns

sys.dm_exec_cursors

sys.dm_exec_plan_attributes

sys.dm_exec_query_plan

sys.dm_exec_sql_text

sysmail_add_principalprofile_sp (Transact-SQL)

sysmail_delete_principalprofile_sp (Transact-SQL)

sysmail_delete_profile_sp (Transact-SQL)

sysmail_help_principalprofile_sp (Transact-SQL)

sysmail_update_principalprofile_sp (Transact-SQL)

Table Hint (Transact-SQL)

table_constraint (Transact-SQL)

UPDATE STATISTICS (Transact-SQL)

Arrow icon used with Back to Top linkBack to Top

See Also

Concepts

New and Updated Books Online Topics (1 February 2007)
Language Reference: New and Updated Topics (17 July 2006)
Language Reference: New and Updated Topics (14 April 2006)
What's New in SQL Server 2005 SP2

Help and Information

Getting SQL Server 2005 Assistance