MirrorAddress sysname RemoteService Name sysname Statistic On Schedule Statistic FileGroup sysname ID int IsAutoCreated bit IsFromIndexCreation bit LastUpdated datetime NoAutomaticRecomputation bit FilterDefinition varbinary(max) HasFilter bit Name sysname Stored On Change: Prevent Stored procedure AnsiNullsStatus bit Procedure On Change: Log CreateDate datetime On Schedule ForReplication bit ID int ImplementationType IsEncrypted bit IsSystemObject bit Owner sysname QuotedIdentifierStatus bit Recompile bit Startup bit AssemblyName sysname ClassName sysname ExecutionContext ExecutionContextPrincipal sysname IsSchemaOwned bit MethodName sysname Schema sysname Name sysname Surface Area On Change: Log Server AdHocRemoteQueriesEnabled bit On Schedule DatabaseMailEnabled bit ClrIntegrationEnabled bit OleAutomationEnabled bit RemoteDacEnabled bit (System.Boolean) bit SqlMailEnabled (System.Boolean) bit WebAssistantEnabled bit XPCmdShellEnabled bit
MirrorAddress RemoteService Name sysname sysname Statistic On Schedule Statistic FileGroup ID IsAutoCreated IsFromIndexCreation LastUpdated NoAutomaticRecomputation FilterDefinition HasFilter Name sysname int bit bit datetime bit varbinary(max) bit sysname Stored Procedure On Change: Prevent On Change: Log On Schedule Stored procedure AnsiNullsStatus CreateDate ForReplication ID ImplementationType IsEncrypted IsSystemObject Owner QuotedIdentifierStatus Recompile Startup AssemblyName ClassName ExecutionContext ExecutionContextPrincipal IsSchemaOwned MethodName Schema Name bit datetime bit int bit bit sysname bit bit bit sysname sysname sysname bit sysname sysname sysname Surface Area On Change: Log On Schedule Server AdHocRemoteQueriesEnabled DatabaseMailEnabled ClrIntegrationEnabled OleAutomationEnabled RemoteDacEnabled (System.Boolean) SqlMailEnabled (System.Boolean) WebAssistantEnabled XPCmdShellEnabled bit bit bit bit bit bit bit bit bit
SQLServer2008PolicyBasedManagement.docx