View XML Schema Collection Partition On Schedule Partition function CreateDate datetime Function ID int NumberOfPartitions int RangeType Name sysname Partition On Schedule Partition scheme ID int Scheme NextUsedFileGroup sysname PartitionFunction sysname Name sysname Plan Guide On Schedule Plan guide Hints ID Int IsDisabled Bit Parameters ScopeBatch ScopeObjectName ScopeSchemaName ScopeType Statement Name sysname Remote On Schedule Remote service CertificateUser sysname Service binding IsAnonymous bit Binding Owner sysname RemoteService sysname Name sysname Resource On Schedule Resource ClassifierFunction sysname Governor governor Enabled bit ReconfigurePending bit Resource On Change: Prevent Resource pool ID int Pool On Change: Log IsSystemObject bit On Schedule MaximumCpuPercentage int MaximumMemoryPercentage int MinimumCpuPercentage int MinimumMemoryPercentage int Name sysname Rule On Schedule Rule CreateDate datetime ID int DateLastModified datetime sysname
View XML Schema Collection Partition Function On Schedule Partition function CreateDate ID NumberOfPartitions RangeType Name datetime int int sysname Partition Scheme On Schedule Partition scheme ID NextUsedFileGroup PartitionFunction Name int sysname sysname sysname Plan Guide On Schedule Plan guide Hints ID IsDisabled Parameters ScopeBatch ScopeObjectName ScopeSchemaName ScopeType Statement Name Int Bit sysname Remote Service Binding On Schedule Remote service binding CertificateUser IsAnonymous Owner RemoteService Name sysname bit sysname sysname sysname Resource Governor On Schedule Resource governor ClassifierFunction Enabled ReconfigurePending sysname bit bit Resource Pool On Change: Prevent On Change: Log On Schedule Resource pool ID IsSystemObject MaximumCpuPercentage MaximumMemoryPercentage MinimumCpuPercentage MinimumMemoryPercentage Name int bit int int int int sysname Rule On Schedule Rule CreateDate ID DateLastModified datetime int datetime sysname
SQLServer2008PolicyBasedManagement.docx