Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Language Reference
Transact-SQL Reference
System Stored Procedures (Transact-SQL)
Database Engine Stored Procedures (Transact-SQL)
sp_add_data_file_recover_suspect_db (Transact-SQL)
sp_addextendedproc (Transact-SQL)
sp_addextendedproperty (Transact-SQL)
sp_add_log_file_recover_suspect_db (Transact-SQL)
sp_addmessage (Transact-SQL)
sp_addtype (Transact-SQL)
sp_addumpdevice (Transact-SQL)
sp_altermessage (Transact-SQL)
sp_attach_db (Transact-SQL)
sp_attach_single_file_db (Transact-SQL)
sp_autostats (Transact-SQL)
sp_batch_params (Transact-SQL)
sp_bindefault (Transact-SQL)
sp_bindrule (Transact-SQL)
sp_bindsession (Transact-SQL)
sp_certify_removable (Transact-SQL)
sp_configure (Transact-SQL)
sp_control_plan_guide (Transact-SQL)
sp_create_plan_guide (Transact-SQL)
sp_create_removable (Transact-SQL)
sp_createstats (Transact-SQL)
sp_datatype_info (Transact-SQL)
sp_db_vardecimal_storage_format (Transact-SQL)
sp_dbcmptlevel (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_dboption (Transact-SQL)
sp_dbremove (Transact-SQL)
sp_delete_backuphistory (Transact-SQL)
sp_delete_database_backuphistory (Transact-SQL)
sp_depends (Transact-SQL)
sp_detach_db (Transact-SQL)
sp_dropdevice (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
sp_dropextendedproperty (Transact-SQL)
sp_dropmessage (Transact-SQL)
sp_droptype (Transact-SQL)
sp_estimated_rowsize_reduction_for_vardecimal (Transact-SQL)
sp_executesql (Transact-SQL)
sp_get_query_template
sp_getapplock (Transact-SQL)
sp_getbindtoken (Transact-SQL)
sp_help (Transact-SQL)
sp_helpconstraint (Transact-SQL)
sp_helpdb (Transact-SQL)
sp_helpdevice (Transact-SQL)
sp_helpextendedproc (Transact-SQL)
sp_helpfile (Transact-SQL)
sp_helpfilegroup (Transact-SQL)
sp_helpgroup (Transact-SQL)
sp_helpindex (Transact-SQL)
sp_helplanguage (Transact-SQL)
sp_helpserver (Transact-SQL)
sp_helpsort (Transact-SQL)
sp_helpstats (Transact-SQL)
sp_helptext (Transact-SQL)
sp_helptrigger (Transact-SQL)
sp_indexoption (Transact-SQL)
sp_invalidate_textptr (Transact-SQL)
sp_lock (Transact-SQL)
sp_monitor (Transact-SQL)
sp_procoption (Transact-SQL)
sp_recompile (Transact-SQL)
sp_refreshsqlmodule (Transact-SQL)
sp_refreshview (Transact-SQL)
sp_releaseapplock (Transact-SQL)
sp_rename (Transact-SQL)
sp_renamedb (Transact-SQL)
sp_resetstatus (Transact-SQL)
sp_setnetname (Transact-SQL)
sp_settriggerorder (Transact-SQL)
sp_spaceused (Transact-SQL)
sp_tableoption (Transact-SQL)
sp_unbindefault (Transact-SQL)
sp_unbindrule (Transact-SQL)
sp_updateextendedproperty (Transact-SQL)
sp_updatestats (Transact-SQL)
sp_validname (Transact-SQL)
sp_who (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_dbmmonitordropmonitoring (Transact-SQL)

SQL Server 2005

New: 14 April 2006

Stops and deletes the mirroring monitor job for all the databases on the server instance.

Topic link icon Transact-SQL Syntax Conventions

Copy 

sp_dbmmonitordropmonitoring

None

Requires membership in the sysadmin fixed server role.

The following example drops database mirroring monitoring on all of the mirrored databases on the server instance.

Copy 
EXEC sp_dbmmonitordropmonitoring ;
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.