ID MaximumFileSize MaximumFileSizeUnit int MaximumRolloverFiles bigint OnFailure QueueDelay int ReserveDiskSpace tinyint Name int int sysname Backup On Schedule Backup device BackupDeviceType tinyint PhysicalLocation nvarchar(260) Device SkipTapeLabel bit Name sysname Broker On Schedule Broker priority ContractName sysname Priority ID int LocalServiceName sysname PriorityLevel tinyint RemoteServiceName sysname Name sysname Broker On Schedule Broker service ID int Service IsSystemObject bit Owner sysname QueueName sysname QueueSchema sysname Name Certificate ActiveForServiceBrokerDialog bit Certificate On Schedule ExpirationDate datetime ID int Issuer nvarchar(442) Owner sysname PrivateKeyEncryptionType char(2) Serial nvarchar(64) Sid varbinary(85) StartDate datetime Subject nvarchar(4000) Thumbprint varbinary(32) LastBackupDate datetime Name sysname Credential On Schedule Credential CreateDate datetime DateLastModified datetime ID int Identity nvarchar(4000) MappedClassType nvarchar(100) ProviderName Name sysname
ID MaximumFileSize MaximumFileSizeUnit MaximumRolloverFiles OnFailure QueueDelay ReserveDiskSpace Name int bigint int tinyint int int sysname Backup Device On Schedule Backup device BackupDeviceType PhysicalLocation SkipTapeLabel Name tinyint nvarchar(260) bit sysname Broker Priority On Schedule Broker priority ContractName ID LocalServiceName PriorityLevel RemoteServiceName Name sysname int sysname tinyint sysname sysname Broker Service On Schedule Broker service ID IsSystemObject Owner QueueName QueueSchema Name int bit sysname sysname sysname Certificate On Schedule Certificate ActiveForServiceBrokerDialog ExpirationDate ID Issuer Owner PrivateKeyEncryptionType Serial Sid StartDate Subject Thumbprint LastBackupDate Name bit datetime int nvarchar(442) sysname char(2) nvarchar(64) varbinary(85) datetime nvarchar(4000) varbinary(32) datetime sysname Credential On Schedule Credential CreateDate DateLastModified ID Identity MappedClassType ProviderName Name datetime datetime int nvarchar(4000) nvarchar(100) sysname
SQLServer2008PolicyBasedManagement.docx