sys.sp_dbmmonitorresults

Description

Returns status rows for a monitored database from the status table in which database mirroring monitoring history is stored, and allows you to choose whether the procedure obtains the latest status beforehand. Specifies the database for which to return mirroring status. Specifies the quantity of rows returned. , and can be one of these values.

Syntax

sp_dbmmonitorresults
[ @database_name = ]
N
'database_name'
[ , [ @mode = ] mode ]
[ , [ @update_table = ] update_table ]
[ ; ]

Examples

Example 1

local_time

Example 2

sp_dbmmonitorresults

Example 3

msdb

Example 4

msdb

Example 5

sp_dbmmonitorupdate

Example 6

msdb

Example 7

USE msdb;
EXECUTE sp_dbmmonitorresults AdventureWorks2022, 2, 0;