G-Productions | dm_db_mirroring_past


	Home Microsoft SQL Server DigiMailing iRN Contact	Keyword

Views

Functions

sys.dm_db_mirroring_past_actions

This is a view in the mssqlsystemresource database. The view indicates the state of mirrors.

Column name Data type Description

mirroring_guid

uniqueidentifier

state_machine_name

nvarchar(120)

action_type

nvarchar(120)

name

nvarchar(120)

current_state

nvarchar(120)

action_sequence

int

Syntax


CREATE VIEW sys.dm_db_mirroring_past_actions AS SELECT * FROM OpenRowSet(TABLE DBMIRROR_PAST_ACTIONS)

Last revision 2008RTM

News


	Query a named instance Sybase+ASE+silent+install SQL 2008 R2 Deprecated procedures in SQL2008 Reporting Services item-level role definitions Create all your missing indexes Converting datetime field Start MSSQL Server Profiler at time Replicating MSSQL Server views Exploring Microsoft Sharepoint The OLE DB provider "SQLNCLI10" for linked server indicates. Mobile solar charger Oracle to SQL Server replication Cannot insert the value NULL into column Undocumented Microsoft SQL Server 2008 VMware Zoekmachine optimalisatie SQL Servers hidden objects FckEditor Flash in Ajax De hype die AJAX heet Barcode scannen MySQL; Gratis, makkelijk en snel! PHP sIFR; de combinatie tussen HTML en Flash