MZ@ !L!This program cannot be run in DOS mode. $PEL@C!   @ ` y P K  @  H.text  `.rsrc  @@.reloc @  @B H$ P ;k er.log_id er.event_type er.log_date er.description er.process_id er.mailitem_id er.account_id er.last_mod_date er.last_mod_user  create table #tmp_sp_helpdiagrams ([Database] sysname not null, Name sysname not null, ID int not null, Owner sysname null, OwnerID int not null) insert into #tmp_sp_helpdiagrams exec dbo.sp_helpdiagrams drop table #tmp_sp_helpdiagrams 'Server[@Name=' + quotename(cast(serverproperty(N'Servername') as sysname),'''') + ']/Database[@Name=' + quotename(db_name(),'''') + ']/DatabaseDiagram[@Name=' + quotename(tshd.Name,'''') + ' and @OwnerID=' + quotename(cast(tshd.OwnerID as nvarchar(30)),'''') + ']' tshd.Name tshd.ID tshd.Owner tshd.OwnerID  CREATE TABLE #tmp_computed_field( ComputedFieldId int, NotificationClassId int, FieldName nvarchar(255), SqlExpression nvarchar(4000), FieldDigestGrouping bit ) INSERT #tmp_computed_field EXEC [SchemaPrefix].NSGetComputedFields DROP TABLE #tmp_computed_field cf.ComputedFieldId cf.FieldName cf.SqlExpression cf.FieldDigestGrouping  CREATE TABLE #tmp_notification_field( NotificationFieldId int, NotificationClassId int, FieldName nvarchar(255), FieldType nvarchar(255), FieldDigestGrouping bit ) INSERT #tmp_notification_field EXEC [SchemaPrefix].NSGetNotificationFields DROP TABLE #tmp_notification_field nf.NotificationFieldId nf.FieldName nf.FieldType nf.FieldDigestGrouping  CREATE TABLE #tmp_event_field( EventFieldId int, EventClassId int, FieldName nvarchar(255), FieldType nvarchar(255), FieldTypeMods nvarchar(255) ) INSERT #tmp_event_field EXEC [SchemaPrefix].NSGetEventFields DROP TABLE #tmp_event_field ef.EventFieldId ef.FieldName ef.FieldType ef.FieldTypeMods  CREATE TABLE #tmp_subscription_chronicle( SubscriptionChronicleId int, ChronicleName nvarchar(255), SubscriptionClassId int, SqlStatementsXml nvarchar(max) ) INSERT #tmp_subscription_chronicle EXEC [SchemaPrefix].NSGetSubscriptionChronicles DROP TABLE #tmp_subscription_chronicle sch.ChronicleName null 9 CREATE TABLE #tmp_condition_scheduled_rule( RuleId int, RuleName nvarchar(255), RuleType tinyint, Action ntext, ActionTimeout int, EventClassId int, SubscriptionClassId int, EventClassName nvarchar(255), InputTypeName nvarchar (128), InputTypeSchema nvarchar (128), SqlUserName nvarchar (128), SqlLoginName nvarchar (128) ) INSERT #tmp_condition_scheduled_rule EXEC [SchemaPrefix].NSGetRulesOnType @RuleType = 4 DROP TABLE #tmp_condition_scheduled_rule csr.RuleName csr.Action csr.ActionTimeout csr.InputTypeName csr.InputTypeSchema csr.SqlUserName csr.SqlLoginName ) CREATE TABLE #tmp_subscription_scheduled_rule( RuleId int, RuleName nvarchar(255), RuleType tinyint, Action ntext, ActionTimeout int, EventClassId int, SubscriptionClassId int, EventClassName nvarchar(255), InputTypeName nvarchar (128), InputTypeSchema nvarchar (128), SqlUserName nvarchar (128), SqlLoginName nvarchar (128) ) INSERT #tmp_subscription_scheduled_rule EXEC [SchemaPrefix].NSGetRulesOnType @RuleType = 2 DROP TABLE #tmp_subscription_scheduled_rule ssr.RuleName ssr.Action ssr.ActionTimeout  CREATE TABLE #tmp_condition_event_rule( RuleId int, RuleName nvarchar(255), RuleType tinyint, Action ntext, ActionTimeout int, EventClassId int, SubscriptionClassId int, EventClassName nvarchar(255), InputTypeName nvarchar (128), InputTypeSchema nvarchar (128), SqlUserName nvarchar (128), SqlLoginName nvarchar (128) ) INSERT #tmp_condition_event_rule EXEC [SchemaPrefix].NSGetRulesOnType @RuleType = 3 DROP TABLE #tmp_condition_event_rule cer.RuleName cer.Action cer.ActionTimeout cer.EventClassName cer.InputTypeName cer.InputTypeSchema cer.SqlUserName cer.SqlLoginName  CREATE TABLE #tmp_subscription_event_rule( RuleId int, RuleName nvarchar(255), RuleType tinyint, Action ntext, ActionTimeout int, EventClassId int, SubscriptionClassId int, EventClassName nvarchar(255), InputTypeName nvarchar (128), InputTypeSchema nvarchar (128), SqlUserName nvarchar (128), SqlLoginName nvarchar (128) ) INSERT #tmp_subscription_event_rule EXEC [SchemaPrefix].NSGetRulesOnType @RuleType = 1 DROP TABLE #tmp_subscription_event_rule ser.RuleName ser.Action ser.ActionTimeout ser.EventClassName  CREATE TABLE #tmp_subscription_field( SubscriptionFieldId int, SubscriptionClassId int, FieldName nvarchar(255), FieldType nvarchar(255), FieldTypeMods nvarchar(255) ) INSERT #tmp_subscription_field EXEC [SchemaPrefix].NSGetSubscriptionFields DROP TABLE #tmp_subscription_field sf.SubscriptionFieldId sf.FieldName sf.FieldType sf.FieldTypeMods  CREATE TABLE #tmp_subscription_class( SubscriptionClassId int, SubscriptionClassName nvarchar(255), FileGroup nvarchar(128), IndexSqlStatementsXml nvarchar(max) ) INSERT #tmp_subscription_class EXEC [SchemaPrefix].NSGetSubscriptionClasses DROP TABLE #tmp_subscription_class sc.SubscriptionClassName sc.FileGroup null - CREATE TABLE #tmp_protocol_field( ProtocolFieldId int, NotificationClassProtocolId int, FieldName nvarchar(255), FieldReference nvarchar(255), SqlExpression nvarchar(4000) ) INSERT #tmp_protocol_field EXEC [SchemaPrefix].NSGetProtocolFields DROP TABLE #tmp_protocol_field pf.FieldName pf.ProtocolFieldId pf.SqlExpression pf.FieldReference  CREATE TABLE #tmp_protocol_retry_schedule( ProtocolRetryScheduleId int, NotificationClassProtocolId int, IntervalOrdinal tinyint, Interval int ) INSERT #tmp_protocol_retry_schedule EXEC [SchemaPrefix].NSGetProtocolRetrySchedules DROP TABLE #tmp_protocol_retry_schedule prs.ProtocolRetryScheduleId prs.Interval prs.IntervalOrdinal  CREATE TABLE #tmp_protocols( NotificationClassProtocolId int, NotificationClassProtocolName nvarchar(255), NotificationClassId int, FailureEventLogInterval int, FailuresBeforeEventLog int, FailuresBeforeAbort int, MulticastRecipientLimit int, WorkItemTimeout int ) INSERT #tmp_protocols EXEC [SchemaPrefix].NSGetNotificationClassProtocols DROP TABLE #tmp_protocols p.NotificationClassProtocolName p.NotificationClassProtocolId p.FailureEventLogInterval p.FailuresBeforeEventLog p.FailuresBeforeAbort p.MulticastRecipientLimit p.WorkItemTimeout  CREATE TABLE #tmp_content_formatter_argument( ContentFormatterArgumentId int, ContentFormatterId int, ArgumentName nvarchar(255), ArgumentValue nvarchar(4000) ) INSERT #tmp_content_formatter_argument EXEC [SchemaPrefix].NSGetContentFormatterArguments DROP TABLE #tmp_content_formatter_argument cfa.ArgumentName cfa.ArgumentValue  CREATE TABLE #tmp_content_formatter( ContentFormatterId int, NotificationClassId int, ClassName nvarchar(255), AssemblyName nvarchar(max) ) INSERT #tmp_content_formatter EXEC [SchemaPrefix].NSGetContentFormatter DROP TABLE #tmp_content_formatter cf.ClassName cf.AssemblyName l CREATE TABLE #tmp_notification_class( NotificationClassId int, NotificationClassName nvarchar(255), DigestDelivery bit, MulticastDelivery bit, ExpirationAge int, FileGroup nvarchar(128), NotificationBatchSize int, ContentFormatterId int, ClassName nvarchar(255), AssemblyName nvarchar (260) ) INSERT #tmp_notification_class EXEC [SchemaPrefix].NSGetNotificationClasses DROP TABLE #tmp_notification_class nc.NotificationClassName nc.DigestDelivery nc.MulticastDelivery nc.ExpirationAge nc.NotificationBatchSize nc.FileGroup nc.ContentFormatterId nc.ClassName nc.AssemblyName  CREATE TABLE #tmp_hosted_event_provider_argument( ProviderArgumentId int, ProviderId int, ArgumentName nvarchar(255), ArgumentValue nvarchar(4000) ) INSERT #tmp_hosted_event_provider_argument EXEC [SchemaPrefix].NSGetProviderArguments DROP TABLE #tmp_hosted_event_provider_argument hepa.ArgumentName hepa.ArgumentValue  CREATE TABLE #tmp_hosted_event_provider( ProviderId int, ProviderName nvarchar(255), ProviderClassName nvarchar(255), AssemblyName nvarchar(260), SystemName nvarchar(255), StartTime datetime, Interval int, Timeout int, ActivationState tinyint ) INSERT #tmp_hosted_event_provider EXEC [SchemaPrefix].NSGetProviders 'HostedOnly' DROP TABLE #tmp_hosted_event_provider hep.ProviderName hep.ProviderId hep.ProviderClassName hep.AssemblyName hep.SystemName hep.StartTime hep.Interval hep.Timeout hep.ActivationState ! CREATE TABLE #tmp_nh_event_provider( ProviderId int, ProviderName nvarchar(255), ProviderClassName nvarchar(255), AssemblyName nvarchar(260), SystemName nvarchar(255), StartTime datetime, Interval int, Timeout int, ActivationState tinyint ) INSERT #tmp_nh_event_provider EXEC [SchemaPrefix].NSGetProviders 'NonHostedOnly' DROP TABLE #tmp_nh_event_provider nhep.ProviderName nhep.ProviderId nhep.ActivationState  CREATE TABLE #tmp_event_chronicle_rule( RuleId int, RuleName nvarchar(255), RuleType tinyint, Action ntext, ActionTimeout int, EventClassId int, SubscriptionClassId int, EventClassName nvarchar(255), InputTypeName nvarchar (128), InputTypeSchema nvarchar (128), SqlUserName nvarchar (128), SqlLoginName nvarchar (128) ) INSERT #tmp_event_chronicle_rule EXEC [SchemaPrefix].NSGetRulesOnType @RuleType = 0 DROP TABLE #tmp_event_chronicle_rule ecr.RuleName ecr.Action ecr.ActionTimeout r CREATE TABLE #tmp_event_chronicle( EventChronicleId int, ChronicleName nvarchar(255), EventClassId int, SqlStatementsXml nvarchar(max) ) INSERT #tmp_event_chronicle EXEC [SchemaPrefix].NSGetEventChronicles DROP TABLE #tmp_event_chronicle echn.ChronicleName null  CREATE TABLE #tmp_event_class( EventClassId int, EventClassName nvarchar(255), FileGroup nvarchar(128), IndexSqlStatementsXml nvarchar(max), RuleId int, RuleName nvarchar(255), RuleType tinyint, Action ntext, ActionTimeout int ) INSERT #tmp_event_class EXEC [SchemaPrefix].NSGetEventClassesWithSqlStatements DROP TABLE #tmp_event_class evt.EventClassName evt.FileGroup null evt.RuleId evt.RuleName evt.RuleType evt.Action evt.ActionTimeout  CREATE TABLE #tmp_distributors( DistributorId int, DistributorName nvarchar(255), SystemName nvarchar(255), ThreadPoolSize int, QuantumDuration int, ActivationState tinyint ) INSERT #tmp_distributors EXEC [SchemaPrefix].NSGetDistributors DROP TABLE #tmp_distributors dds.DistributorName dds.DistributorId dds.SystemName dds.ThreadPoolSize dds.QuantumDuration dds.ActivationState n CREATE TABLE #tmp_vacuum_schedule( VacuumScheduleId int, StartTime datetime, Interval int ) INSERT #tmp_vacuum_schedule EXEC [SchemaPrefix].NSGetVacuumSchedule DROP TABLE #tmp_vacuum_schedule dvs.VacuumScheduleId dvs.StartTime dvs.Interval , CREATE TABLE #tmp_application_names( ApplicationName nvarchar(max), ApplicationDb nvarchar(128), AppSchemaName nvarchar (128), DropOnDelete bit, ApplicationEnabled bit, SubscribersEnabled bit, SubscriptionsEnabled bit, EventProviderEnabled bit, GeneratorEnabled bit, DistributorEnabled bit, ) INSERT #tmp_application_names EXEC [SchemaPrefix].NSGetApplicationNames CREATE TABLE #tmp_local_application_details( ApplicationName nvarchar(max), BaseDirectoryPath nvarchar(260), ApplicationDefinitionFilePath nvarchar(260), QuantumDuration int, ChronicleQuantumLimit int, SubscriptionQuantumLimit int, ProcessEventsInOrder bit, RetentionAge int, PerformanceQueryInterval int, EventThrottle int, SubscriptionThrottle int, NotificationThrottle int, LogBeforeDeliveryAttempts bit, LogStatusInfo bit, LogNotificationText bit, ) CREATE TABLE #tmp_application_version( ApplicationName nvarchar(max), ApplicationDatabase nvarchar (255), SchemaName nvarchar (255), VersionId int, UpdateDescription nvarchar(255), UpdateStarted datetime, UpdateFinished datetime, UpdateUserId nvarchar(255), NSEdition nvarchar(255), NSVersionMajor int, NSVersionMinor int, NSVersionBuild int, NSVersionRevision int, ConfigVersionMajor int, ConfigVersionMinor int, ConfigVersionBuild int, ConfigVersionRevision int, AdfVersionMajor int, AdfVersionMinor int, AdfVersionBuild int, AdfVersionRevision int ) CREATE TABLE #tmp_generator_details( ApplicationName nvarchar(max), GeneratorId int, GeneratorName nvarchar(255), SystemName nvarchar(255), PreviousFiringTime datetime, ThreadPoolSize int, ActivationState tinyint ) DECLARE @dbname7 sysname DECLARE @AppSchemaName nvarchar(128) DECLARE @sql7 NVARCHAR(MAX) DECLARE applications_cursor CURSOR FOR SELECT ApplicationDb, AppSchemaName FROM #tmp_application_names FOR READ ONLY OPEN applications_cursor FETCH applications_cursor into @dbname7, @AppSchemaName WHILE @@FETCH_STATUS >= 0 BEGIN SET @sql7 = CONVERT (NVARCHAR (MAX), N' USE ' + quotename(@dbname7)) SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' INSERT #tmp_local_application_details EXEC ' + quotename (@AppSchemaName) + N'.NSGetApplicationConfig') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' INSERT #tmp_application_version EXEC ' + quotename (@AppSchemaName) + N'.NSGetVersionInfo') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' INSERT #tmp_generator_details EXEC ' + quotename (@AppSchemaName) + N'.NSGetGenerators') EXEC (@sql7) FETCH applications_cursor into @dbname7, @AppSchemaName END CLOSE applications_cursor DEALLOCATE applications_cursor CREATE TABLE #tmp_application_details( applicationdb nvarchar(max), name nvarchar(max), AppSchemaName nvarchar(128), ApplicationEnabled bit, SubscribersEnabled bit, SubscriptionsEnabled bit, EventProviderEnabled bit, GeneratorEnabled bit, DistributorEnabled bit, BaseDirectoryPath nvarchar(260), ApplicationDefinitionFilePath nvarchar(260), QuantumDuration int, ChronicleQuantumLimit int, SubscriptionQuantumLimit int, ProcessEventsInOrder bit, RetentionAge int, PerformanceQueryInterval int, EventThrottle int, SubscriptionThrottle int, NotificationThrottle int, LogBeforeDeliveryAttempts bit, LogStatusInfo bit, LogNotificationText bit, NSVersionMajor int, NSVersionMinor int, NSVersionBuild int, NSVersionRevision int, AdfVersionMajor int, AdfVersionMinor int, AdfVersionBuild int, AdfVersionRevision int, GeneratorId int, GeneratorName nvarchar(255) ) DECLARE @ApplicationName nvarchar (128) DECLARE application_details_cursor CURSOR FOR SELECT ApplicationName, ApplicationDb FROM #tmp_application_names FOR READ ONLY OPEN application_details_cursor FETCH application_details_cursor into @ApplicationName, @dbname7 WHILE @@FETCH_STATUS >= 0 BEGIN SET @sql7 = CONVERT (NVARCHAR (MAX), N' USE ' + quotename(@dbname7)) SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' INSERT #tmp_application_details') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' SELECT app.ApplicationDb, app.ApplicationName, app.AppSchemaName, ') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' app.ApplicationEnabled, app.SubscribersEnabled, app.SubscriptionsEnabled,') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' app.EventProviderEnabled, app.GeneratorEnabled, app.DistributorEnabled,') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' cfg.BaseDirectoryPath, cfg.ApplicationDefinitionFilePath,') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' cfg.QuantumDuration, cfg.ChronicleQuantumLimit, cfg.SubscriptionQuantumLimit,') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' cfg.ProcessEventsInOrder, cfg.RetentionAge, cfg.PerformanceQueryInterval, cfg.EventThrottle, cfg.SubscriptionThrottle,') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' cfg.NotificationThrottle, cfg.LogBeforeDeliveryAttempts, cfg.LogStatusInfo, cfg.LogNotificationText, ') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' ver.NSVersionMajor, ver.NSVersionMinor, ver.NSVersionBuild, ver.NSVersionRevision,') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' ver.AdfVersionMajor, ver.AdfVersionMinor, ver.AdfVersionBuild, ver.AdfVersionRevision,') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' gen.GeneratorId, gen.GeneratorName') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' FROM #tmp_local_application_details as cfg, #tmp_application_version as ver, #tmp_generator_details as gen, #tmp_application_names as app') SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' WHERE app.ApplicationName = N' + quotename (@ApplicationName, N'''')) SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' AND cfg.ApplicationName = N' + quotename (@ApplicationName, N'''')) SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' AND ver.ApplicationName = N' + quotename (@ApplicationName, N'''')) SET @sql7 = @sql7 + CONVERT (NVARCHAR (MAX), N' AND gen.ApplicationName = N' + quotename (@ApplicationName, N'''')) EXEC (@sql7) FETCH application_details_cursor into @ApplicationName, @dbname7 END CLOSE application_details_cursor DEALLOCATE application_details_cursor DROP TABLE #tmp_application_details DROP TABLE #tmp_generator_details DROP TABLE #tmp_application_version DROP TABLE #tmp_local_application_details DROP TABLE #tmp_application_names dad.name dad.applicationdb dad.AppSchemaName null null dad.BaseDirectoryPath dad.ApplicationDefinitionFilePath dad.QuantumDuration dad.ChronicleQuantumLimit dad.SubscriptionQuantumLimit dad.ProcessEventsInOrder dad.PerformanceQueryInterval dad.EventThrottle dad.SubscriptionThrottle dad.NotificationThrottle dad.LogBeforeDeliveryAttempts dad.LogStatusInfo dad.LogNotificationText dad.RetentionAge dad.ApplicationEnabled dad.SubscribersEnabled dad.SubscriptionsEnabled dad.EventProviderEnabled dad.GeneratorEnabled dad.DistributorEnabled dad.GeneratorId dad.GeneratorName : CREATE TABLE #tmp_InstLogFiles ( LogicalName nvarchar(128), FilePath nvarchar(260), FileGroupName nvarchar(128), InitialSize nvarchar(32), MaxSize nvarchar(32), GrowthIncrement nvarchar(16) ) INSERT INTO #tmp_InstLogFiles EXEC [SchemaPrefix].NSGetDatabaseFiles 'LOG_ONLY' DROP TABLE #tmp_InstLogFiles ilf.LogicalName ilf.FilePath ilf.InitialSize ilf.MaxSize ilf.GrowthIncrement  CREATE TABLE #tmp_InstDatabaseFiles ( LogicalName nvarchar(128), FilePath nvarchar(260), FileGroupName nvarchar(128), InitialSize nvarchar(32), MaxSize nvarchar(32), GrowthIncrement nvarchar(16) ) INSERT INTO #tmp_InstDatabaseFiles EXEC [SchemaPrefix].NSGetDatabaseFiles 'DATA_ONLY' DROP TABLE #tmp_InstDatabaseFiles idf.LogicalName idf.FilePath idf.FileGroupName idf.InitialSize idf.MaxSize idf.GrowthIncrement  CREATE TABLE #tmp_InstDatabaseFiles1 ( LogicalName nvarchar(128), FilePath nvarchar(260), FileGroupName nvarchar(128), InitialSize nvarchar(32), MaxSize nvarchar(32), GrowthIncrement nvarchar(16) ) CREATE TABLE #tmp_InstanceDatabaseFileGroups ( FileGroupName nvarchar(128) ) INSERT INTO #tmp_InstDatabaseFiles1 EXEC [SchemaPrefix].NSGetDatabaseFiles 'DATA_ONLY' INSERT INTO #tmp_InstanceDatabaseFileGroups SELECT DISTINCT FileGroupName FROM #tmp_InstDatabaseFiles1 DROP TABLE #tmp_InstanceDatabaseFileGroups DROP TABLE #tmp_InstDatabaseFiles1 idfg.FileGroupName i CREATE TABLE #tmp_InstDatabaseOptions ( SystemName nvarchar(255), DefaultFileGroup nvarchar(128), CollationName nvarchar(255) ) INSERT INTO #tmp_InstDatabaseOptions EXEC [SchemaPrefix].NSGetDatabaseOptions DROP TABLE #tmp_InstDatabaseOptions ido.SystemName ido.DefaultFileGroup ido.CollationName 1 CREATE TABLE #tmp_AppLogFiles ( LogicalName nvarchar(128), FilePath nvarchar(260), FileGroupName nvarchar(128), InitialSize nvarchar(32), MaxSize nvarchar(32), GrowthIncrement nvarchar(16) ) INSERT INTO #tmp_AppLogFiles EXEC [SchemaPrefix].NSGetDatabaseFiles 'LOG_ONLY' DROP TABLE #tmp_AppLogFiles alf.LogicalName alf.FilePath alf.InitialSize alf.MaxSize alf.GrowthIncrement  CREATE TABLE #tmp_AppDatabaseFiles ( LogicalName nvarchar(128), FilePath nvarchar(260), FileGroupName nvarchar(128), InitialSize nvarchar(32), MaxSize nvarchar(32), GrowthIncrement nvarchar(16) ) INSERT INTO #tmp_AppDatabaseFiles EXEC [SchemaPrefix].NSGetDatabaseFiles 'DATA_ONLY' DROP TABLE #tmp_AppDatabaseFiles adf.LogicalName adf.FilePath adf.FileGroupName adf.InitialSize adf.MaxSize adf.GrowthIncrement  CREATE TABLE #tmp_AppDatabaseFiles1 ( LogicalName nvarchar(128), FilePath nvarchar(260), FileGroupName nvarchar(128), InitialSize nvarchar(32), MaxSize nvarchar(32), GrowthIncrement nvarchar(16) ) CREATE TABLE #tmp_ApplicationDatabaseFileGroups ( FileGroupName nvarchar(128) ) INSERT INTO #tmp_AppDatabaseFiles1 EXEC [SchemaPrefix].NSGetDatabaseFiles 'DATA_ONLY' INSERT INTO #tmp_ApplicationDatabaseFileGroups SELECT DISTINCT FileGroupName FROM #tmp_AppDatabaseFiles1 DROP TABLE #tmp_ApplicationDatabaseFileGroups DROP TABLE #tmp_AppDatabaseFiles1 adfg.FileGroupName ` CREATE TABLE #tmp_AppDatabaseOptions ( SystemName nvarchar(255), DefaultFileGroup nvarchar(128), CollationName nvarchar(255) ) INSERT INTO #tmp_AppDatabaseOptions EXEC [SchemaPrefix].NSGetDatabaseOptions DROP TABLE #tmp_AppDatabaseOptions ado.SystemName ado.DefaultFileGroup ado.CollationName  CREATE TABLE #tmp_generators( ApplicationName nvarchar(max), GeneratorId int, GeneratorName nvarchar(255), SystemName nvarchar(255), PreviousFiringTime datetime, ThreadPoolSize int, ActivationState tinyint ) INSERT #tmp_generators EXEC [SchemaPrefix].NSGetGenerators DROP TABLE #tmp_generators gen.GeneratorName gen.GeneratorId gen.SystemName gen.PreviousFiringTime gen.ThreadPoolSize gen.ActivationState s CREATE TABLE #tmp_protocol_definitions( ProtocolName nvarchar(255), ClassName nvarchar(255), AssemblyName nvarchar(260) ) INSERT #tmp_protocol_definitions EXEC [SchemaPrefix].NSGetProtocols 0 DROP TABLE #tmp_protocol_definitions dpd.ProtocolName dpd.ClassName dpd.AssemblyName t CREATE TABLE #tmp_delivery_channels_args( DeliveryChannelName nvarchar(255), ArgumentName nvarchar(255), ArgumentValue nvarchar(4000) ) INSERT #tmp_delivery_channels_args EXEC [SchemaPrefix].NSGetDeliveryChannelArguments DROP TABLE #tmp_delivery_channels_args dcab.ArgumentName dcab.ArgumentValue  CREATE TABLE #tmp_delivery_channels( DeliveryChannelName nvarchar(255), ProtocolName nvarchar(255) ) INSERT #tmp_delivery_channels EXEC [SchemaPrefix].NSGetDeliveryChannels DROP TABLE #tmp_delivery_channels dcb.DeliveryChannelName dcb.ProtocolName  CREATE TABLE #tmp_instance_db_names ( Name nvarchar(64), InstanceDatabase nvarchar (255), SchemaName nvarchar (255), VersionId int, UpdateDescription nvarchar (255), UpdateStarted datetime, UpdateFinished datetime, UpdateUserId nvarchar (255), NSEdition nvarchar(255), NSVersionMajor int, NSVersionMinor int, NSVersionBuild int, NSVersionRevision int, ConfigVersionMajor int, ConfigVersionMinor int, ConfigVersionBuild int, ConfigVersionRevision int, AdfVersionMajor int, AdfVersionMinor int, AdfVersionBuild int, AdfVersionRevision int, EncryptArguments bit ) CREATE TABLE #tmp_instance_info ( Name nvarchar(64), InstanceDatabase nvarchar (255), SchemaName nvarchar (255), VersionId int, UpdateDescription nvarchar (255), UpdateStarted datetime, UpdateFinished datetime, UpdateUserId nvarchar (255), NSEdition nvarchar(255), NSVersionMajor int, NSVersionMinor int, NSVersionBuild int, NSVersionRevision int, ConfigVersionMajor int, ConfigVersionMinor int, ConfigVersionBuild int, ConfigVersionRevision int, AdfVersionMajor int, AdfVersionMinor int, AdfVersionBuild int, AdfVersionRevision int ) CREATE TABLE #tmp_instance_encryption ( Name nvarchar(64), EncryptArguments bit ) IF OBJECT_ID(N'msdb.NS90.NSInstances') IS NOT NULL BEGIN DECLARE @dbname NVARCHAR (255) DECLARE @SchemaName NVARCHAR (255) DECLARE @sql NVARCHAR(MAX) DECLARE instance_db_names_cursor CURSOR FOR SELECT DatabaseName, SchemaName FROM [msdb].[NS90].[NSInstances] FOR READ ONLY OPEN instance_db_names_cursor FETCH instance_db_names_cursor into @dbname, @SchemaName WHILE @@FETCH_STATUS >= 0 BEGIN SET @sql = CONVERT (NVARCHAR (MAX), N' USE ' + quotename(@dbname)) SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' IF OBJECT_ID(N' + quotename (quotename (@SchemaName) + N'.NSGetVersionInfo', N'''') + N') IS NOT NULL') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' BEGIN') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' IF EXISTS (SELECT * FROM sys.columns AS Columns WHERE Columns.object_id = OBJECT_ID (N' + quotename (quotename (@SchemaName) + N'.NSInstanceConfig', N'''') + N') AND Columns.name = ''EncryptArguments'')') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' BEGIN') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' INSERT #tmp_instance_info') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' EXEC ' + quotename (@SchemaName) + N'.NSGetVersionInfo') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' INSERT #tmp_instance_encryption') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' EXEC ' + quotename (@SchemaName) + N'.NSGetInstanceConfig') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' END') SET @sql = @sql + CONVERT (NVARCHAR (MAX), N' END') EXEC (@sql) FETCH instance_db_names_cursor into @dbname, @SchemaName END INSERT INTO #tmp_instance_db_names SELECT Info.Name, Info.InstanceDatabase, Info.SchemaName, Info.VersionId, Info.UpdateDescription, Info.UpdateStarted, Info.UpdateFinished, Info.UpdateUserId, Info.NSEdition, Info.NSVersionMajor, Info.NSVersionMinor, Info.NSVersionBuild, Info.NSVersionRevision, Info.ConfigVersionMajor, Info.ConfigVersionMinor, Info.ConfigVersionBuild, Info.ConfigVersionRevision, Info.AdfVersionMajor, Info.AdfVersionMinor, Info.AdfVersionBuild, Info.AdfVersionRevision, Config.EncryptArguments FROM #tmp_instance_info AS Info, #tmp_instance_encryption AS Config WHERE Info.Name = Config.Name CLOSE instance_db_names_cursor DEALLOCATE instance_db_names_cursor END DROP TABLE #tmp_instance_encryption DROP TABLE #tmp_instance_info DROP TABLE #tmp_instance_db_names dtb.Name dtb.InstanceDatabase dtb.SchemaName null null dtb.EncryptArguments  serverproperty(N'Servername')  ke.thumbprint (case ke.crypt_type when 'ESKS' then 0 when 'EPUC' then 1 when 'ESKP' then 2 when 'EPUA' then 3 when 'ESKM' then 4 else -1 end) ke.crypt_property  c.symmetric_key_id = 101 ok.key_id=c.symmetric_key_id and ok.database_id=db_id() mkdb.database_id=db_id() c.create_date c.modify_date ISNULL(ok.status, 0) ISNULL(mkdb.is_master_key_encrypted_by_server, 0) ~ < @account_name is not null declare @SysAdminOnly int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'SysAdminOnly', @SysAdminOnly OUTPUT set @SysAdminOnly = (case when 0 = @SysAdminOnly then 1 else 0 end) create table #tmpProxyAccountName ( domain sysname, username sysname) insert into #tmpProxyAccountName exec master.dbo.xp_sqlagent_proxy_account N'GET' declare @account_name nvarchar(255) set @account_name = (select domain + N'\' + username as [UserName] from #tmpProxyAccountName) if (@account_name is null) begin set @account_name=N'' end drop table #tmpProxyAccountName @account_name is not null declare @SysAdminOnly int set @SysAdminOnly = (select count(*) from sys.credentials c where c.name = N'##xp_cmdshell_proxy_account##') declare @account_name nvarchar(4000) set @account_name = (select top 1 credential_identity from sys.credentials c where c.name = N'##xp_cmdshell_proxy_account##') if (@account_name is null) begin set @account_name=N'' end @SysAdminOnly @account_name  create table #tmp_sp_help_category (category_id int null, category_type tinyint null, name nvarchar(128) null) insert into #tmp_sp_help_category (category_id, category_type, name) exec msdb.dbo.sp_help_category 'OPERATOR' drop table #tmp_sp_help_category tshc.name tshc.category_id } dt.transaction_id = ts.transaction_id tsnp.transaction_id = ts.transaction_id ta.transaction_id = ts.transaction_id ta.name ts.transaction_id ta.transaction_begin_time ts.session_id db_name(dt.database_id) dt.database_id dt.database_transaction_begin_time case when tsnp.transaction_id is null then 0 else 1 end dt.transaction_id = tsnp.transaction_id ta.transaction_id = tsnp.transaction_id ta.name tsnp.transaction_id ta.transaction_begin_time tsnp.session_id db_name(dt.database_id) dt.database_id dt.database_transaction_begin_time 1 B create table #tmp_sp_help_category (category_id int null, category_type tinyint null, name nvarchar(128) null) insert into #tmp_sp_help_category (category_id, category_type, name) exec msdb.dbo.sp_help_category 'JOB' drop table #tmp_sp_help_category tshc.name tshc.category_id tshc.category_type  create table #tmp_sp_help_category (category_id int null, category_type tinyint null, name nvarchar(128) null) insert into #tmp_sp_help_category (category_id, category_type, name) exec msdb.dbo.sp_help_category 'ALERT' drop table #tmp_sp_help_category tshc.name tshc.category_id i ke.thumbprint (case ke.crypt_type when 'ESKS' then 0 when 'EPUC' then 1 when 'ESKP' then 2 when 'EPUA' then 3 when 'ESKM' then 4 end) ke.crypt_property  ((s.type = 4) AND (s.drop_lsn IS NULL))  CASE param.isoutparam WHEN 1 THEN param.isoutparam WHEN 0 THEN CASE param.name WHEN '' THEN 1 ELSE 0 END END param.is_output nsp.colid = 1 and nsp.number > 1 nsp.number object_name(nsp.id) + ';' + cast(nsp.number as nvarchar(20)) nsp.encrypted nsp.procedure_number object_name(nsp.object_id) + ';' + cast(nsp.procedure_number as nvarchar(20)) CASE WHEN nsp.definition IS NULL THEN 1 ELSE 0 END o clmns.number = 0 and 0 = OBJECTPROPERTY(clmns.id, N'IsScalarFunction') " param.name param.colid param.parameter_id null ) tbl.name like '#%' use tempdb  sp.principal_id = a.principal_id a.name a.asymmetric_key_id user_name(a.principal_id) (case a.algorithm when '1R' then 0 when '2R' then 1 when '2R' then 3 end) a.key_length case a.pvt_key_encryption_type when 'NA' then 0 when 'MK' then 1 when 'PW' then 2 end a.public_key a.sid a.thumbprint  c.symmetric_key_id <> 101 ok.key_id=c.symmetric_key_id and ok.database_id=db_id() c.name c.symmetric_key_id user_name(c.principal_id) c.create_date c.key_guid c.key_length (case c.key_algorithm when 'R2' then 0 when 'R4' then 1 when 'D' then 2 when 'D3' then 3 when 'DX' then 4 when 'A1' then 5 when 'A2' then 6 when 'A3' then 7 end) c.modify_date ISNULL(ok.status, 0) ] ewm.method_alias ISNULL(ewm.namespace,'') ewm.result_format ewm.object_name ewm.result_schema case upper(se.login_type) when 'WINDOWS' then 2 else 1 end  te.port te.is_dynamic_port ISNULL(te.ip_address,'') w ISNULL(he.authorization_realm,N'') he.clear_port ISNULL(he.default_logon_domain,N'') 1*he.is_ssl_port_enabled + 2*is_clear_port_enabled he.ssl_port he.url_path he.site he.is_compression_enabled 1*is_anonymous_enabled + 2*is_basic_auth_enabled + 4*is_digest_auth_enabled + 8*is_integrated_auth_enabled  ve.discriminator  cert.certificate_id = sbe.certificate_id sbe.is_message_forwarding_enabled sbe.message_forwarding_size ISNULL(cert.name,N'') case when sbe.encryption_algorithm = 0 then 0 when sbe.encryption_algorithm in (3,4,7,8) then 1 when sbe.encryption_algorithm in (1,2,5,6) then 2 else 0 end case sbe.encryption_algorithm when 0 then 0 when 1 then 1 when 2 then 2 when 3 then 1 when 4 then 2 when 5 then 4 when 6 then 3 when 7 then 4 when 8 then 3 else 0 end sbe.connection_auth  cert.certificate_id = dme.certificate_id dme.role ISNULL(cert.name,N'') case when dme.encryption_algorithm = 0 then 0 when dme.encryption_algorithm in (3,4,7,8) then 1 when dme.encryption_algorithm in (1,2,5,6) then 2 else 0 end case dme.encryption_algorithm when 0 then 0 when 1 then 1 when 2 then 2 when 3 then 1 when 4 then 2 when 5 then 4 when 6 then 3 when 7 then 4 when 8 then 3 else 0 end dme.connection_auth   ISNULL(se.default_database, N'') se.is_sql_language_enabled se.default_namespace 2-convert(int, se.is_xml_charset_enforced) se.default_result_schema se.wsdl_generator_procedure case LEN(ISNULL(se.wsdl_generator_procedure,'')) when 0 then 0 else 2 end se.is_session_enabled se.session_timeout CASE WHEN se.session_timeout < 0 THEN 1 ELSE 0 END 6 sp.principal_id = e.principal_id e.name e.endpoint_id sp.name e.type e.protocol e.state e.is_admin_endpoint  drop table #account_server_tmp ast.servername ast.port ISNULL(ast.username, N'') ast.servertype ast.use_default_credentials ast.enable_ssl  drop table #principal_profile_tmp ppt.principal_name ppt.principal_id ppt.profile_name ppt.profile_id ppt.is_default  drop table #profile_account_tmp pat.profile_name pat.profile_id pat.account_name pat.account_id pat.sequence_number  te.type te.type_desc cast(db_id() as varchar(20)) + '_' + cast(te.object_id as varchar(20)) B null  te.type te.type_desc cast(db_id() as varchar(20)) + '_' + cast(te.object_id as varchar(20)) b sm{0}.object_id = {0}.object_id ssm{0}.object_id = {0}.object_id ISNULL(sm{0}.uses_ansi_nulls, ssm{0}.uses_ansi_nulls) ISNULL(sm{0}.uses_quoted_identifier, ssm{0}.uses_quoted_identifier) OBJECTPROPERTYEX({0}.object_id, N'IsSchemaBound')  tr.parent_class = 100 mod.object_id = tr.object_id am2tr.object_id = tr.object_id ssmod.object_id = tr.object_id asmbl.assembly_id = mod.assembly_id ~tr.is_disabled CASE WHEN tr.type = N'TR' THEN N'' ELSE asmbl.name END CASE WHEN tr.type = N'TR' THEN N'' ELSE mod.assembly_class END CASE WHEN tr.type = N'TR' THEN N'' ELSE mod.assembly_method END CASE WHEN tr.type = N'TR' THEN 1 WHEN tr.type = N'TA' THEN 2 ELSE 1 END ssmod.uses_ansi_nulls ssmod.uses_quoted_identifier ISNULL(user_name(ssmod.execute_as_principal_id),ISNULL(user_name(mod.execute_as_principal_id),N'')) CASE WHEN (ssmod.execute_as_principal_id IS NULL AND mod.execute_as_principal_id IS NULL) THEN 1 ELSE 2 END NULL NULL CASE WHEN ssmod.definition IS NULL THEN 1 ELSE 0 END null  tr.parent_class = 0 am2tr.object_id = tr.object_id sqlmod.object_id = tr.object_id tr.is_not_for_replication ~tr.is_disabled CASE WHEN tr.type = N'TR' THEN 1 WHEN tr.type = N'TA' THEN 2 ELSE 1 END sqlmod.uses_ansi_nulls sqlmod.uses_quoted_identifier  {0}.name {0}.id {0}.crdate {0}.name {0}.object_id {0}.create_date {0}.modify_date m { create table #tmp_sysmail_help_configure(paramname nvarchar(256), paramvalue nvarchar(256) null, description nvarchar(256) null) insert into #tmp_sysmail_help_configure(paramname, paramvalue, description) exec msdb.dbo.sysmail_help_configure_sp drop table #tmp_sysmail_help_configure tshc.paramname tshc.paramvalue tshc.description  create table #tmp_sysmail_help_account(account_id int, name nvarchar(128), description nvarchar(256) null, email_address nvarchar(128) null, display_name nvarchar(128) null, replyto_address nvarchar(128) null, servertype nvarchar(128), servername nvarchar(128), port int, username nvarchar(128), use_default_credentials bit, enable_ssl bit) insert into #tmp_sysmail_help_account(account_id, name, description, email_address, display_name, replyto_address, servertype, servername, port, username, use_default_credentials, enable_ssl) exec msdb.dbo.sysmail_help_account_sp drop table #tmp_sysmail_help_account tsha.name tsha.account_id ISNULL(tsha.description, N'') tsha.email_address ISNULL(tsha.display_name, N'') ISNULL(tsha.replyto_address, N'') + create table #tmp_sysmail_help_profile(profile_id int, name nvarchar(128), description nvarchar(256) null) insert into #tmp_sysmail_help_profile(profile_id, name, description) exec msdb.dbo.sysmail_help_profile_sp drop table #tmp_sysmail_help_profile tshp.name tshp.profile_id ISNULL(tshp.description,N'') ) s.name s.credential_id s.credential_identity s.create_date s.modify_date   comp.name comp.xml_component_id comp.xml_namespace_id comp.is_qualified (case comp.kind when 'N' then 1 when 'Z' then 2 when 'P' then 3 when 'S' then 4 when 'L' then 5 when 'U' then 6 when 'C' then 7 when 'K' then 8 when 'E' then 9 when 'M' then 10 when 'W' then 11 when 'A' then 12 when 'G' then 13 when 'V' then 14 else 1 end) (case comp.derivation when 'N' then 1 when 'X' then 2 when 'R' then 3 when 'S' then 4 else 1 end) comp.base_xml_component_id comp.scoping_xml_component_id  xsc2.xml_collection_id = xn.xml_collection_id xsc.schema_id = sch2.schema_id xn.name xn.xml_namespace_id XML_SCHEMA_NAMESPACE(sch2.Name, xsc2.name, xn.name)  xsc.schema_id <> 4 xsc.schema_id = sch.schema_id xsc.name xsc.xml_collection_id sch.name xsc.create_date xsc.modify_date XML_SCHEMA_NAMESPACE(sch.Name, xsc.name) X dmw.database_name dmw.principal_server_name dmw.mirror_server_name dmw.safety_level dmw.safety_sequence_number dmw.role_sequence_number dmw.mirroring_guid dmw.family_guid dmw.is_suspended dmw.is_suspended_sequence_number  create table #err_fulltext_text_tmp(Text nvarchar(4000), ArchiveNo int null, ctlgid int null, LogDate datetime null, ProcessInfo nvarchar(100) null) declare @text_offset int declare @process_info_length int set @text_offset = 34 set @process_info_length = 10 drop table #err_fulltext_text_tmp ert.LogDate ert.ProcessInfo ert.Text  drop table #fulltext_log_tmp er.ArchiveNo er.ArchiveNo CONVERT(datetime, er.CreateDate, 101) er.Size  o.provider_name=op.Name create table #OLEDBProv (id int identity(1,1), Name sysname NOT NULL, ParseName sysname NOT NULL,Description sysname NOT NULL ) insert #OLEDBProv (Name, ParseName,Description) EXECUTE master.dbo.xp_enum_oledb_providers insert #OLEDBProv (Name, ParseName,Description) EXECUTE master.dbo.sp_enum_oledb_providers delete from #OLEDBProv where exists ( select 1 from #OLEDBProv oprov where oprov.Name = #OLEDBProv.Name and oprov.id < #OLEDBProv.id ) create table #oledbprop (allow_in_process bit, disallow_adhoc_access bit, dynamic_parameters bit, index_as_access_path bit, level_zero_only bit, nested_queries bit, non_transacted_updates bit, sql_server_like bit, provider_name sysname null) declare name_cursor cursor local fast_forward FOR (select Name from #OLEDBProv) open name_cursor DECLARE @providername sysname FETCH NEXT FROM name_cursor INTO @providername WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN SELECT @providername = RTRIM(@providername) declare @regpath nvarchar(255) set @regpath = N'SOFTWARE\Microsoft\MSSQLServer\Providers\' + @providername declare @allow_in_process int declare @disallow_adhoc_access int declare @dynamic_parameters int declare @index_as_access_path int declare @level_zero_only int declare @nested_queries int declare @non_transacted_updates int declare @sql_server_like int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'AllowInProcess', @allow_in_process OUTPUT exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'DisallowAdHocAccess', @disallow_adhoc_access OUTPUT exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'DynamicParameters', @dynamic_parameters OUTPUT exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'IndexAsAccessPath', @index_as_access_path OUTPUT exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'LevelZeroOnly', @level_zero_only OUTPUT exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'NestedQueries', @nested_queries OUTPUT exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'NonTransactedUpdates', @non_transacted_updates OUTPUT exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regpath, 'SqlServerLIKE', @sql_server_like OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'AllowInProcess', @allow_in_process OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'DisallowAdHocAccess', @disallow_adhoc_access OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'DynamicParameters', @dynamic_parameters OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'IndexAsAccessPath', @index_as_access_path OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'LevelZeroOnly', @level_zero_only OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'NestedQueries', @nested_queries OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'NonTransactedUpdates', @non_transacted_updates OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @regpath, 'SqlServerLIKE', @sql_server_like OUTPUT insert #oledbprop (allow_in_process, disallow_adhoc_access, dynamic_parameters, index_as_access_path, level_zero_only, nested_queries, non_transacted_updates, sql_server_like, provider_name) select IsNull(@allow_in_process, 0), IsNull(@disallow_adhoc_access, 0), IsNull(@dynamic_parameters, 0), IsNull(@index_as_access_path, 0), IsNull(@level_zero_only, 0), IsNull(@nested_queries, 0), IsNull(@non_transacted_updates, 0), IsNull(@sql_server_like, 0), @providername END FETCH NEXT FROM name_cursor INTO @providername END CLOSE name_cursor DEALLOCATE name_cursor create table #oledbprop (allow_in_process bit, disallow_adhoc_access bit, dynamic_parameters bit, index_as_access_path bit, level_zero_only bit, nested_queries bit, non_transacted_updates bit, sql_server_like bit, provider_name sysname null) declare name_cursor cursor local fast_forward FOR (select Name from #OLEDBProv) open name_cursor DECLARE @providername sysname FETCH NEXT FROM name_cursor INTO @providername WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN SELECT @providername = RTRIM(@providername) insert #oledbprop (provider_name, allow_in_process, disallow_adhoc_access, dynamic_parameters, index_as_access_path, level_zero_only, nested_queries, non_transacted_updates, sql_server_like) exec master.dbo.sp_MSset_oledb_prop @providername END FETCH NEXT FROM name_cursor INTO @providername END CLOSE name_cursor DEALLOCATE name_cursor drop table #oledbprop drop table #OLEDBProv op.Name op.Description o.allow_in_process o.disallow_adhoc_access o.dynamic_parameters o.index_as_access_path o.level_zero_only o.nested_queries o.non_transacted_updates o.sql_server_like w c.name c.certificate_id user_name(c.principal_id) case c.pvt_key_encryption_type when 'NA' then 0 when 'MK' then 1 when 'PW' then 2 end c.issuer_name c.cert_serial_number c.sid c.subject c.expiry_date c.start_date c.thumbprint c.is_active_for_begin_dialog G create table #tmp_sp_enum_login_for_proxy(proxy_id int null, proxy_name nvarchar(128), flags int null, name nvarchar(128) null, sid varbinary(85) null, principal_id int null ) insert into #tmp_sp_enum_login_for_proxy(proxy_id, proxy_name, flags, name, sid, principal_id) exec msdb.dbo.sp_enum_login_for_proxy drop table #tmp_sp_enum_login_for_proxy spl.name spl.flags \ create table #tmp_sp_enum_sqlagent_subsystems (subsystem nvarchar(max) null, description nvarchar(max) null, subsystem_dll nvarchar(max) null, agent_exe nvarchar(max) null, start_entry_point nvarchar(max) null, event_entry_point nvarchar(max) null, stop_entry_point nvarchar(max) null, max_worker_threads int null, subsystem_id int null) create table #tmp_sp_help_proxy_subsystem(subsystem nvarchar(max) null, proxy_id int null, name nvarchar(128) null, credential_identity nvarchar(128) null, enabled tinyint null, description nvarchar(1024) null, user_sid varbinary(40) null, credential_id int null, credential_identity_exists int null) insert into #tmp_sp_enum_sqlagent_subsystems(subsystem, description, subsystem_dll, agent_exe, start_entry_point, event_entry_point, stop_entry_point, max_worker_threads, subsystem_id) exec msdb.dbo.sp_enum_sqlagent_subsystems declare @subsystem nvarchar(max) declare @login sysname set @login = suser_sname() declare crs insensitive cursor for ( select subsystem from #tmp_sp_enum_sqlagent_subsystems ) for read only open crs fetch crs into @subsystem while @@fetch_status >= 0 begin if 'TSQL' != @subsystem begin insert into #tmp_sp_help_proxy_subsystem(proxy_id, name, credential_identity, enabled, description, user_sid, credential_id, credential_identity_exists) exec msdb.dbo.sp_help_proxy @subsystem_name = @subsystem, @name = @login update #tmp_sp_help_proxy_subsystem set subsystem = @subsystem where subsystem is null end fetch crs into @subsystem end close crs deallocate crs drop table #tmp_sp_help_proxy_subsystem drop table #tmp_sp_enum_sqlagent_subsystems tsepfs.subsystem F sc.credential_id = tshp.credential_id create table #tmp_sp_help_proxy(proxy_id int null, name nvarchar(128) null, credential_identity nvarchar(128) null, enabled tinyint null, description nvarchar(1024) null, user_sid varbinary(40) null, credential_id int null, credential_identity_exists int null) insert into #tmp_sp_help_proxy(proxy_id, name, credential_identity, enabled, description, user_sid, credential_id, credential_identity_exists) exec msdb.dbo.sp_help_proxy drop table #tmp_sp_help_proxy tshp.name tshp.proxy_id tshp.enabled ISNULL(tshp.description,N'') tshp.credential_id ISNULL(sc.name,N'') ISNULL(tshp.credential_identity,N'')  l.database_name l.mark_name l.description l.user_name l.lsn l.mark_time  s.plan_id s.plan_name s.date_created s.owner s.max_history_rows s.remote_history_server s.max_remote_history_rows s.log_shipping  ld.line1 ld.line2 ld.line3 ld.line4 ld.line5 ld.server_name ld.start_time ld.end_time ld.error_number ld.error_message ld.command ld.succeeded  spl.task_detail_id spl.start_time spl.end_time spl.succeeded < sp.subplan_name sp.subplan_id sp.subplan_description sp.job_id sp.schedule_id  s.name s.id s.description s.create_date s.owner s.version_major s.version_minor s.version_build s.version_comments   param.number = 1 CASE param.isoutparam WHEN 1 THEN param.isoutparam WHEN 0 THEN CASE param.name WHEN '' THEN 1 ELSE 0 END END param.is_output dmi.database_id = dtb.database_id dtb.status & 1 dtb.status & 4194304 dtb.is_ansi_null_default_on dtb.is_ansi_nulls_on dtb.is_ansi_padding_on dtb.is_ansi_warnings_on dtb.is_arithabort_on dtb.is_auto_close_on dtb.is_auto_create_stats_on dtb.is_auto_shrink_on dtb.is_auto_update_stats_on dtb.is_cursor_close_on_commit_on dtb.is_concat_null_yields_null_on dtb.is_numeric_roundabort_on dtb.is_quoted_identifier_on dtb.is_read_only dtb.is_recursive_triggers_on dtb.is_local_cursor_default dtb.page_verify_option dtb.recovery_model dtb.user_access dtb.snapshot_isolation_state dtb.is_db_chaining_on dtb.is_auto_update_stats_async_on dtb.is_date_correlation_on dtb.is_broker_enabled dtb.is_trustworthy_on dtb.is_parameterization_forced (case dmi.mirroring_redo_queue_type when N'UNLIMITED' then 0 else dmi.mirroring_redo_queue end) dmi.mirroring_connection_timeout DATABASEPROPERTYEX(dtb.name, 'IsAnsiNullDefault') DATABASEPROPERTYEX(dtb.name, 'IsAnsiNullsEnabled') DATABASEPROPERTYEX(dtb.name, 'IsAnsiPaddingEnabled') DATABASEPROPERTYEX(dtb.name, 'IsAnsiWarningsEnabled') DATABASEPROPERTYEX(dtb.name, 'IsArithmeticAbortEnabled') DATABASEPROPERTYEX(dtb.name, 'IsAutoCreateStatistics') DATABASEPROPERTYEX(dtb.name, 'IsAutoUpdateStatistics') DATABASEPROPERTYEX(dtb.name, 'IsCloseCursorsOnCommitEnabled') DATABASEPROPERTYEX(dtb.name, 'IsNullConcat') DATABASEPROPERTYEX(dtb.name, 'IsNumericRoundAbortEnabled') DATABASEPROPERTYEX(dtb.name, 'IsQuotedIdentifiersEnabled') DATABASEPROPERTY(dtb.name, 'IsReadOnly') DATABASEPROPERTYEX(dtb.name, 'IsRecursiveTriggersEnabled') DATABASEPROPERTYEX(dtb.name, 'IsLocalCursorsDefault') CASE WHEN 1=DATABASEPROPERTYEX(dtb.name, 'IsTornPageDetectionEnabled') THEN 1 ELSE 0 END CASE DATABASEPROPERTYEX(dtb.name, 'Recovery') WHEN 'SIMPLE' THEN 3 WHEN 'BULK_LOGGED' THEN 2 ELSE /*FULL*/ 1 END CASE CONVERT(sysname,DATABASEPROPERTYEX(dtb.name, 'UserAccess')) WHEN 'SINGLE_USER' THEN 1 WHEN 'RESTRICTED_USER' THEN 2 ELSE /*MULTI_USER*/ 0 END 1 DATABASEPROPERTY(dtb.name, 'IsAnsiNullDefault') DATABASEPROPERTY(dtb.name, 'IsAnsiNullsEnabled') DATABASEPROPERTY(dtb.name, 'IsAnsiWarngingsEnabled') DATABASEPROPERTY(dtb.name, 'IsAutoCreateStatistics') DATABASEPROPERTY(dtb.name, 'IsAutoUpdateStatistics') DATABASEPROPERTY(dtb.name, 'IsCloseCursorsOnCommitEnabled') DATABASEPROPERTY(dtb.name, 'IsQuotedIdentifiersEnabled') DATABASEPROPERTY(dtb.name, 'IsRecursiveTriggersEnabled') DATABASEPROPERTY(dtb.name, 'IsLocalCursorsDefault') CASE WHEN 1=DATABASEPROPERTY(dtb.name, 'IsTruncLog') THEN CASE WHEN 1=DATABASEPROPERTY(dtb.name, 'IsBulkCopy') THEN NULL ELSE 3/*SIMPLE=trunc. log on chkpt.*/ END WHEN 1=DATABASEPROPERTY(dtb.name, 'IsBulkCopy') THEN 2 /*BULK_LOGGED*/ ELSE 1 END /*FULL*/ CASE DATABASEPROPERTY(dtb.name, 'IsSingleUser') WHEN 1 THEN 1 ELSE (CASE DATABASEPROPERTY(dtb.name,'IsDboOnly') WHEN 0 THEN 0/*MULTI_USER*/ ELSE 1 END) END D 8 6 @  drop table #contig_tmp declare @database_id int select @database_id = db_id() null null null null null null null null fi.Level fi.Pages fi.Rows fi.MinimumRecordSize fi.MaximumRecordSize fi.AverageRecordSize fi.ForwardedRecords fi.Extents fi.ExtentSwitches fi.AverageFreeBytes fi.AvgPageFullness fi.ScanDensity fi.BestCount fi.ActualCount fi.LogicalFragmentation fi.ExtentFragmentation fi.index_depth fi.page_count fi.record_count fi.min_record_size_in_bytes fi.max_record_size_in_bytes fi.avg_record_size_in_bytes fi.forwarded_record_count fi.avg_page_space_used_in_percent fi.index_type_desc fi.partition_number fi.ghost_record_count fi.version_ghost_record_count fi.avg_fragmentation_in_percent  N'' N'' N'' N'' 5 sms.error > 50000 sms.msglangid = sl.lcid sms.message_id > 50000 sms.language_id = sl.lcid sms.error sms.dlevel sms.severity sms.description sms.msglangid sl.name sms.message_id sms.is_event_logged sms.severity sms.text sms.language_id sl.name z sms.error < 50001 sms.msglangid = sl.lcid sms.message_id < 50001 sms.language_id = sl.lcid sms.error sms.dlevel sms.severity sms.description sms.msglangid sl.name sms.message_id sms.is_event_logged sms.severity sms.text sms.language_id sl.name  sp.principal_id = prmssn.major_id and prmssn.class = 101 null sp.name NULL NULL prmssn.major_id c.certificate_id = prmssn.major_id and prmssn.class = 106 null c.name NULL NULL prmssn.major_id e.endpoint_id = prmssn.major_id and prmssn.class = 105 null e.name NULL NULL prmssn.major_id  obj.object_id = prmssn.major_id and prmssn.class = 1 null object_name(prmssn.id) user_name(prmssn.uid) null prmssn.id obj.name schema_name(obj.schema_id) COL_NAME(prmssn.major_id,prmssn.minor_id) prmssn.major_id obj.schema_id = prmssn.major_id and prmssn.class = 3 null obj.name null null prmssn.major_id obj.principal_id = prmssn.major_id and prmssn.class = 4 null obj.name null null prmssn.major_id obj.assembly_id = prmssn.major_id and prmssn.class = 5 null obj.name null null prmssn.major_id obj.user_type_id = prmssn.major_id and prmssn.class = 6 null obj.name null null prmssn.major_id obj.fulltext_catalog_id = prmssn.major_id and prmssn.class = 23 null obj.name null null prmssn.major_id C null G null  (( prmssn.action in (193, 197) and ((prmssn.columns & 1) = 1) ) or ( prmssn.action in (195, 196, 224, 26) )) and (convert(tinyint, substring( isnull(prmssn.columns, 0x01), a.low, 1)) & a.high != 0) and a.type = N'P' and a.number = 0 prmssn.minor_id = 0  prmssn.class = 100 null  null  null  val1.number = prmssn.protecttype and val1.type = 'T' val2.number = prmssn.action and val2.type = 'T' grantee_principal.uid = prmssn.uid grantor_principal.uid = prmssn.grantor grantee_principal.principal_id = prmssn.grantee_principal_id grantor_principal.principal_id = prmssn.grantor_principal_id grantee_principal.name + N'_' + convert(nvarchar(10), (CASE when 1 = grantee_principal.issqlrole THEN 3 WHEN 1 = grantee_principal.isapprole THEN 4 ELSE 2 END)) + N'_' + grantor_principal.name + N'_' + convert(nvarchar(10), (CASE when 1 = grantor_principal.issqlrole THEN 3 WHEN 1 = grantor_principal.isapprole THEN 4 ELSE 2 END)) + N'_' + convert(nvarchar(10), (prmssn.id)) + N'_' + convert(nvarchar(10), prmssn.protecttype) + N'_' + convert(nvarchar(10), prmssn.action) grantee_principal.name CASE when 1 = grantee_principal.issqlrole THEN 3 WHEN 1 = grantee_principal.isapprole THEN 4 ELSE 2 END grantor_principal.name CASE when 1 = grantor_principal.issqlrole THEN 3 WHEN 1 = grantor_principal.isapprole THEN 4 ELSE 2 END CASE prmssn.id WHEN 0 THEN 0 ELSE 1 END CASE prmssn.protecttype WHEN 204 THEN 87 WHEN 205 THEN 71 WHEN 206 THEN 68 END prmssn.protecttype val1.name val2.name grantee_principal.name + N'_' + convert(nvarchar(10), (CASE grantee_principal.type WHEN 'R' THEN 3 WHEN 'A' THEN 4 ELSE 2 END - CASE '{0}' WHEN 'database' THEN 0 ELSE 2 END)) + N'_' + grantor_principal.name + N'_' + convert(nvarchar(10), (CASE grantor_principal.type WHEN 'R' THEN 3 WHEN 'A' THEN 4 ELSE 2 END - CASE '{0}' WHEN 'database' THEN 0 ELSE 2 END)) + N'_' + convert(nvarchar(10), (CASE WHEN (prmssn.class=4 or prmssn.class=100 )THEN CASE (SELECT oc.type FROM sys.{0}_principals AS oc WHERE oc.principal_id = prmssn.major_id) WHEN 'R' THEN 201 WHEN 'A' THEN 202 ELSE 200 END + CASE prmssn.class WHEN 4 THEN 0 ELSE 100 END ELSE prmssn.class END)) + N'_' + convert(nvarchar(10), ascii(prmssn.state)) + N'_' + convert(varchar(10), convert(varbinary(10), prmssn.type)) grantee_principal.name CASE grantee_principal.type WHEN 'R' THEN 3 WHEN 'A' THEN 4 ELSE 2 END - CASE '{0}' WHEN 'database' THEN 0 ELSE 2 END grantor_principal.name CASE grantor_principal.type WHEN 'R' THEN 3 WHEN 'A' THEN 4 ELSE 2 END - CASE '{0}' WHEN 'database' THEN 0 ELSE 2 END CASE WHEN (prmssn.class=4 or prmssn.class=100 )THEN CASE (SELECT oc.type FROM sys.{0}_principals AS oc WHERE oc.principal_id = prmssn.major_id) WHEN 'R' THEN 201 WHEN 'A' THEN 202 ELSE 200 END + CASE prmssn.class WHEN 4 THEN 0 ELSE 100 END ELSE prmssn.class END ascii(prmssn.state) prmssn.type prmssn.state  prmssn.id = 0 prmssn.class = 0 null  usr.uid >= 16384 and usr.uid <= 16393 and spv.type = 'DBR' and ((usr.uid = 16384 and spv.number >= 16384 and spv.number < 16392) or (usr.uid <> 16384 and usr.uid = spv.number)) and spv.low > 0 usr.name spv.name  null  declare @SmoActiveDirectory sysname declare @RegPath nvarchar(1024) select @RegPath = N'Software\Microsoft\MSSQLServer\SQLServerSCP\' + db_name() exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @RegPath, N'objectGUID', @SmoActiveDirectory OUTPUT CASE WHEN (@SmoActiveDirectory IS NULL) THEN 0 ELSE 1 END  declare @scmPath sysname select @scmPath = N'Software\Microsoft\MSSQLServer\SQLServerSCP' declare @SmoActiveDirectory sysname exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @scmPath, N'objectGUID', @SmoActiveDirectory OUTPUT DECLARE @res INT CREATE table #temp_ad(result BIT) EXECUTE @res = master.dbo.xp_MSADEnabled if @res = 0 INSERT INTO #temp_ad VALUES (1) else INSERT INTO #temp_ad VALUES (0) DROP table #temp_ad ad.result CASE WHEN (@SmoActiveDirectory IS NULL) THEN 0 ELSE 1 END  DECLARE @instance_name sysname SELECT @instance_name = null SELECT @instance_name = N'SQLAgent:' DECLARE @instance_name sysname SELECT @instance_name = CONVERT(sysname, SERVERPROPERTY('InstanceName')) IF @instance_name IS NULL SELECT @instance_name = N'SQLAgent:' ELSE SELECT @instance_name = N'MSSQLAgent$' + @instance_name + N':' CREATE TABLE #temp_agent_perf_info(object_name nvarchar(256), counter_name nvarchar(256), instance_name nvarchar(256)) CREATE TABLE #temp_job_instances (instance_name nvarchar(20)) INSERT INTO #temp_job_instances VALUES(N'_Total') INSERT INTO #temp_job_instances VALUES(N'Schedules') INSERT INTO #temp_job_instances VALUES(N'Alerts') INSERT INTO #temp_job_instances VALUES(N'Others') -- Job object INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'Jobs' , N'Active Jobs', s.instance_name FROM #temp_job_instances s INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'Jobs' , N'Successful jobs', s.instance_name FROM #temp_job_instances s INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'Jobs' , N'Failed jobs', s.instance_name FROM #temp_job_instances s INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'Jobs' , N'Successful jobs ratio', s.instance_name FROM #temp_job_instances s INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'Jobs' , N'Jobs launched/min', s.instance_name FROM #temp_job_instances s INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'Jobs' , N'Queued jobs', s.instance_name FROM #temp_job_instances s --JobStep object CREATE TABLE #temp_jobstep_instances (subsystem NVARCHAR(40) NULL) insert #temp_jobstep_instances values('ActiveScripting') insert #temp_jobstep_instances values('CmdExec') insert #temp_jobstep_instances values('TSQL') -- Check if replication is installed DECLARE @replication_installed int EXECUTE master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Replication', N'IsInstalled', @replication_installed OUTPUT, N'no_output' EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Replication', N'IsInstalled', @replication_installed OUTPUT, N'no_output' SELECT @replication_installed = ISNULL(@replication_installed, 0) if 1 = @replication_installed begin insert #temp_jobstep_instances values('Distribution') insert #temp_jobstep_instances values('LogReader') insert #temp_jobstep_instances values('Merge') insert #temp_jobstep_instances values('Snapshot') end if 1 = @replication_installed begin insert #temp_jobstep_instances values('QueueReader') end CREATE TABLE #temp_jobstep_instances (subsystem NVARCHAR(40) NULL, description NVARCHAR(80) NULL, subsystem_dll NVARCHAR(255) NULL, agent_exe NVARCHAR(80) NULL, start_entry_point NVARCHAR(30) NULL, event_entry_point NVARCHAR(30) NULL, stop_entry_point NVARCHAR(30) NULL, max_worker_threads INT NULL, subsystem_id INT NULL) INSERT #temp_jobstep_instances EXEC msdb.dbo.sp_enum_sqlagent_subsystems INSERT #temp_jobstep_instances ( subsystem ) VALUES (N'_Total') INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'JobSteps' , N'Active steps', s.subsystem FROM #temp_jobstep_instances s INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'JobSteps' , N'Queued steps', s.subsystem FROM #temp_jobstep_instances s INSERT INTO #temp_agent_perf_info SELECT @instance_name + N'JobSteps' , N'Total Step Retries', s.subsystem FROM #temp_jobstep_instances s --Alert object INSERT INTO #temp_agent_perf_info VALUES(@instance_name + N'Alert' , N'Activated Alerts', NULL) INSERT INTO #temp_agent_perf_info VALUES(@instance_name + N'Alert' , N'Alerts/min', NULL) --General object INSERT INTO #temp_agent_perf_info VALUES(@instance_name + N'Statistics' , N'Server Restarted', NULL) DROP TABLE #temp_job_instances DROP TABLE #temp_agent_perf_info DROP TABLE #temp_jobstep_instances spi.object_name spi.counter_name ISNULL(spi.instance_name,N'')  spi.object_name spi.counter_name ISNULL(spi.instance_name,N'')  ftl.name ftl.lcid < ownobj.type not in ('PK', 'C ', 'F ', 'UQ') and ( ownobj.type != 'D' or 0 = ownobj.parent_object_id) ownobj_parent.object_id = ownobj.parent_object_id null ownobj.schema_id != 4 null ownobj.schema_id != 4 null  ownobj.type not in ( 'K', 'S' ) ownobj_parent.id = ownobj.parent_obj null null null null  COLUMNPROPERTY(cols.id, cols.name, 'IsFulltextIndexed') <> 0 sl.lcid=cols.language col.object_id = icol.object_id and col.column_id = icol.column_id sl.lcid=icol.language_id col2.column_id = icol.type_column_id and col2.object_id = icol.object_id cols.name (select ISNULL(scol2.name,N'') from sysdepends as sdep, syscolumns as scol2 where cols.colid = sdep.number and cols.id = sdep.id and cols.id = scol2.id and sdep.depnumber = scol2.colid) (select ISNULL(scol2.name,N'') from sysdepends as sdep, syscolumns as scol2 where cols.colid = sdep.number and cols.id = sdep.id and sdep.deptype = 1 and cols.id = scol2.id and sdep.depnumber = scol2.colid) sl.alias col.name sl.alias ISNULL(col2.name,N'')  cat.fulltext_catalog_id = fti.fulltext_catalog_id si.index_id=fti.unique_index_id and si.object_id=fti.object_id cat.name fti.is_enabled OBJECTPROPERTY(fti.object_id,'TableFullTextPopulateStatus') (case change_tracking_state when 'M' then 1 when 'A' then 2 else 0 end) OBJECTPROPERTY(fti.object_id,'TableFullTextItemCount') OBJECTPROPERTY(fti.object_id,'TableFullTextDocsProcessed') OBJECTPROPERTY(fti.object_id,'TableFullTextPendingChanges') OBJECTPROPERTY(fti.object_id,'TableFullTextFailCount') si.name 6 dp1.principal_id = s.principal_id s.name s.schema_id dp1.name  cat.data_space_id = fg.data_space_id ci.ftcatid = cat.fulltext_catalog_id cat.principal_id=dp.principal_id ci.ftcatid = cat.ftcatid create table #tmpcatinfo ([ftcatid] smallint,[name] sysname,[path] nvarchar(260),[status] int,[number_fulltext_tables] int) if( 1 = DATABASEPROPERTYEX(db_name(), 'IsFulltextEnabled') ) begin insert #tmpcatinfo execute dbo.sp_help_fulltext_catalogs end create table #tmpcatinfo ([ftcatid] smallint,[name] sysname,[path] nvarchar(260),[status] int,[number_fulltext_tables] int) if( 1 = DATABASEPROPERTY(db_name(), 'IsFulltextEnabled') ) begin insert #tmpcatinfo execute dbo.sp_help_fulltext_catalogs end drop table #tmpcatinfo cat.name cat.fulltext_catalog_id FULLTEXTCATALOGPROPERTY(cat.name,'AccentSensitivity') cat.is_default fg.name dp.name cat.ftcatid FULLTEXTCATALOGPROPERTY(cat.name,'LogSize') FULLTEXTCATALOGPROPERTY(cat.name,'IndexSize') FULLTEXTCATALOGPROPERTY(cat.name,'ItemCount') FULLTEXTCATALOGPROPERTY(cat.name,'UniqueKeyCount') FULLTEXTCATALOGPROPERTY(cat.name,'PopulateStatus') 0 cast(null as datetime) ci.path ci.number_fulltext_tables  DECLARE @FullTextDefaultPath NVARCHAR(512) EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'FullTextDefaultPath', @FullTextDefaultPath OUTPUT @@SERVERNAME serverproperty(N'Servername') ISNULL(FULLTEXTSERVICEPROPERTY('ResourceUsage'), 0) @FullTextDefaultPath ISNULL(FULLTEXTSERVICEPROPERTY('ConnectTimeout'),0) * 10000000 ISNULL(FULLTEXTSERVICEPROPERTY('DataTimeout'),0) * 10000000 0 CASE WHEN FULLTEXTSERVICEPROPERTY('VerifySignature') = 0 THEN 1 WHEN FULLTEXTSERVICEPROPERTY('VerifySignature') = 1 THEN 0 ELSE 0 END FULLTEXTSERVICEPROPERTY('LoadOSResources')  par.is_output = 0 par.name par.parameter_id s obj.type=N'AF' am.object_id = obj.object_id asmbl.assembly_id = am.assembly_id ret_param.object_id = obj.object_id and ret_param.is_output = 1 asmbl.name am.assembly_class + asmbl.assembly_id = atypes.assembly_id atypes.user_type_id atypes.max_length ISNULL(atypes.collation_name,N'') atypes.precision atypes.scale atypes.is_nullable asmbl.name ISNULL(atypes.assembly_class,N'') atypes.is_binary_ordered atypes.is_fixed_length 0 0x0 0  afiles.name afiles.file_id afiles.content 2 princip.principal_id = asmbl.principal_id asmbl.name asmbl.assembly_id asmbl.create_date ISNULL(ASSEMBLYPROPERTY(asmbl.assembly_id, N'CultureInfo'), N'') asmbl.permission_set princip.name asmbl.is_visible ISNULL(ASSEMBLYPROPERTY(asmbl.name, N'PublicKey'), CONVERT(varbinary(8000), N'')) ASSEMBLYPROPERTY(asmbl.name, N'VersionMajor') ASSEMBLYPROPERTY(asmbl.name, N'VersionMinor') ASSEMBLYPROPERTY(asmbl.name, N'VersionBuild') ASSEMBLYPROPERTY(asmbl.name, N'VersionRevision')  drop table #operator_job_notification_tmp ont.JobId ont.JobName ont.NotifyLevelEmail ont.NotifyLevelNetSend ont.NotifyLevelPage  drop table #operator_notification_tmp ont.AlertId ont.AlertName ont.UseEmail ont.UsePager ont.UseNetSend ont.HasEmail ont.HasPager ont.HasNetSend t drop table #alert_notification_tmp ant.OperatorId ant.OperatorName ant.UseEmail ant.UsePager ant.UseNetSend ant.HasEmail ant.HasPager ant.HasNetSend C bkps.backup_set_id = btmp.backup_set_id declare @server_name nvarchar(512) set @server_name = @@SERVERNAME declare @server_name nvarchar(512) set @server_name = cast(serverproperty(N'Servername') as nvarchar(512)) DECLARE @first_full_backupset_id INTEGER ,@first_full_backup_startdate DATETIME CREATE TABLE #backupset( backup_set_id INTEGER NOT NULL ,is_in_restore_plan bit NOT NULL ,backup_start_date datetime NOT NULL ,type CHAR(1) NOT NULL ,database_name nvarchar(256) NOT NULL ) /**********************************************************************/ /* Identify the first */ /**********************************************************************/ SELECT @first_full_backupset_id = backupset_outer.backup_set_id ,@first_full_backup_startdate = backupset_outer.backup_start_date FROM msdb.dbo.backupset backupset_outer WHERE backupset_outer.database_name = @db_name AND backupset_outer.server_name = @server_name AND backupset_outer.type = 'D' -- Full Database Backup AND backupset_outer.backup_start_date = ( SELECT MAX(backupset_inner.backup_start_date) FROM msdb.dbo.backupset backupset_inner WHERE backupset_inner.database_name = backupset_outer.database_name AND backupset_inner.server_name = @server_name AND backupset_inner.type = backupset_outer.type AND backupset_inner.backup_start_date <= @restore_to_datetime) /*******************************************************************************************/ /* Find the first full database backup needed in the restore plan and store its attributes */ /* in #backupset work table */ /*******************************************************************************************/ INSERT #backupset( backup_set_id ,is_in_restore_plan ,backup_start_date ,type ,database_name ) SELECT backup_set_id ,1 -- The full database backup is always needed for the restore plan ,backup_start_date ,type ,database_name FROM msdb.dbo.backupset WHERE msdb.dbo.backupset.backup_set_id = @first_full_backupset_id AND msdb.dbo.backupset.server_name = @server_name /***************************************************************/ /* Find the log and differential backups that occurred after */ /* the full backup and store them in #backupset work table */ /***************************************************************/ INSERT #backupset( backup_set_id ,is_in_restore_plan ,backup_start_date ,type ,database_name ) SELECT backup_set_id ,0 ,backup_start_date ,type ,database_name FROM msdb.dbo.backupset WHERE msdb.dbo.backupset.database_name = @db_name AND msdb.dbo.backupset.server_name = @server_name AND msdb.dbo.backupset.type IN ('I', 'L') -- Differential, Log backups AND msdb.dbo.backupset.backup_start_date >= @first_full_backup_startdate /**********************************************************************************/ /* identify and mark the backup logs that need to be included in the restore plan */ /**********************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'I' AND #backupset.backup_start_date = (SELECT MAX(backupset_inner.backup_start_date) FROM #backupset backupset_inner WHERE backupset_inner.type = #backupset.type AND backupset_inner.backup_start_date <= @restore_to_datetime) /**************************************************************************************/ /* Log backups that occurred after the different are always part of the restore plan. */ /**************************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'L' AND #backupset.backup_start_date <= @restore_to_datetime AND #backupset.backup_start_date >= (SELECT backupset_inner.backup_start_date FROM #backupset backupset_inner WHERE backupset_inner.type = 'I' AND backupset_inner.is_in_restore_plan = 1) /**************************************************************************************/ /* If @restore_to_datetime is greater than the last startdate of the last log backup, */ /* include the next log backup in the restore plan */ /**************************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'L' AND #backupset.backup_start_date = (SELECT MIN(backupset_inner.backup_start_date) FROM #backupset backupset_inner WHERE backupset_inner.type = 'L' AND backupset_inner.backup_start_date > @restore_to_datetime AND backupset_inner.is_in_restore_plan = 0) /**************************************************************************************/ /* If there are no differential backups, all log backups that occurred after the full */ /* backup are needed in the restore plan. */ /**************************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'L' AND #backupset.backup_start_date <= @restore_to_datetime AND NOT EXISTS(SELECT * FROM #backupset backupset_inner WHERE backupset_inner.type = 'I') DECLARE @first_full_backupset_id INTEGER ,@first_full_backup_startdate DATETIME CREATE TABLE #backupset( backup_set_id INTEGER NOT NULL ,is_in_restore_plan bit NOT NULL ,backup_start_date datetime NOT NULL ,type CHAR(1) NOT NULL ,database_name nvarchar(256) NOT NULL ) /**********************************************************************/ /* Identify the first */ /**********************************************************************/ SELECT @first_full_backupset_id = backupset_outer.backup_set_id ,@first_full_backup_startdate = backupset_outer.backup_start_date FROM msdb.dbo.backupset backupset_outer WHERE backupset_outer.database_name = @db_name AND backupset_outer.server_name = @server_name AND backupset_outer.type = 'D' -- Full Database Backup AND backupset_outer.backup_start_date = ( SELECT MAX(backupset_inner.backup_start_date) FROM msdb.dbo.backupset backupset_inner WHERE backupset_inner.database_name = backupset_outer.database_name AND backupset_inner.server_name = @server_name AND backupset_inner.type = backupset_outer.type AND backupset_inner.backup_start_date <= @restore_to_datetime AND backupset_inner.is_copy_only = 0 ) AND backupset_outer.is_copy_only = 0 /*******************************************************************************************/ /* Find the first full database backup needed in the restore plan and store its attributes */ /* in #backupset work table */ /*******************************************************************************************/ INSERT #backupset( backup_set_id ,is_in_restore_plan ,backup_start_date ,type ,database_name ) SELECT backup_set_id ,1 -- The full database backup is always needed for the restore plan ,backup_start_date ,type ,database_name FROM msdb.dbo.backupset WHERE msdb.dbo.backupset.backup_set_id = @first_full_backupset_id AND msdb.dbo.backupset.server_name = @server_name /***************************************************************/ /* Find the log and differential backups that occurred after */ /* the full backup and store them in #backupset work table */ /***************************************************************/ INSERT #backupset( backup_set_id ,is_in_restore_plan ,backup_start_date ,type ,database_name ) SELECT backup_set_id ,0 ,backup_start_date ,type ,database_name FROM msdb.dbo.backupset WHERE msdb.dbo.backupset.database_name = @db_name AND msdb.dbo.backupset.server_name = @server_name AND msdb.dbo.backupset.type IN ('I', 'L') -- Differential, Log backups AND msdb.dbo.backupset.backup_start_date >= @first_full_backup_startdate /**********************************************************************************/ /* identify and mark the backup logs that need to be included in the restore plan */ /**********************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'I' AND #backupset.backup_start_date = (SELECT MAX(backupset_inner.backup_start_date) FROM #backupset backupset_inner WHERE backupset_inner.type = #backupset.type AND backupset_inner.backup_start_date <= @restore_to_datetime) /**************************************************************************************/ /* Log backups that occurred after the different are always part of the restore plan. */ /**************************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'L' AND #backupset.backup_start_date <= @restore_to_datetime AND #backupset.backup_start_date >= (SELECT backupset_inner.backup_start_date FROM #backupset backupset_inner WHERE backupset_inner.type = 'I' AND backupset_inner.is_in_restore_plan = 1) /**************************************************************************************/ /* If @restore_to_datetime is greater than the last startdate of the last log backup, */ /* include the next log backup in the restore plan */ /**************************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'L' AND #backupset.backup_start_date = (SELECT MIN(backupset_inner.backup_start_date) FROM #backupset backupset_inner WHERE backupset_inner.type = 'L' AND backupset_inner.backup_start_date > @restore_to_datetime AND backupset_inner.is_in_restore_plan = 0) /**************************************************************************************/ /* If there are no differential backups, all log backups that occurred after the full */ /* backup are needed in the restore plan. */ /**************************************************************************************/ UPDATE #backupset SET is_in_restore_plan = 1 WHERE #backupset.type = 'L' AND #backupset.backup_start_date <= @restore_to_datetime AND NOT EXISTS(SELECT * FROM #backupset backupset_inner WHERE backupset_inner.type = 'I') drop table #backupset bkps.name bkps.backup_set_id btmp.is_in_restore_plan bkps.backup_set_uuid bkps.media_set_id bkps.first_family_number bkps.first_media_number bkps.last_family_number bkps.last_media_number bkps.catalog_family_number bkps.catalog_media_number bkps.position bkps.expiration_date bkps.software_vendor_id bkps.description bkps.user_name bkps.software_major_version bkps.software_minor_version bkps.software_build_version bkps.time_zone bkps.mtf_minor_version bkps.first_lsn bkps.last_lsn bkps.checkpoint_lsn bkps.database_backup_lsn bkps.database_creation_date bkps.backup_start_date bkps.backup_finish_date bkps.type bkps.sort_order bkps.code_page bkps.compatibility_level bkps.database_version bkps.backup_size bkps.database_name bkps.server_name bkps.machine_name bkps.flags bkps.unicode_locale bkps.unicode_compare_style bkps.collation_name H am{0}.object_id = {0}.object_id asmbl{0}.assembly_id = am{0}.assembly_id case when am{0}.object_id is null then N'' else asmbl{0}.name end case when am{0}.object_id is null then N'' else am{0}.assembly_class end case when am{0}.object_id is null then N'' else am{0}.assembly_method end  sm{0}.object_id = {0}.object_id ssm{0}.object_id = {0}.object_id OBJECTPROPERTYEX({0}.object_id,N'ExecIsAnsiNullsOn') OBJECTPROPERTYEX({0}.object_id,N'ExecIsQuotedIdentOn') OBJECTPROPERTYEX({0}.object_id, N'IsSchemaBound')  tbl.id = {0}.id tbl.object_id = {0}.object_id {0}.name tbl.name user_name(tbl.uid) schema_name(tbl.schema_id) f s{0}.uid = {0}.uid s{0}.schema_id = {0}.schema_id {0}.name s{0}.name  p.major_id=0 AND p.minor_id=0 AND p.class=0 p.name p.value  create table #extprops(owner sysname null, parentobjname sysname null, objname sysname null, name sysname , value sql_variant null) drop table #extprops < create table #extprops(owner sysname null, parentobjname sysname null, objname sysname null, name sysname , value sql_variant null) drop table #extprops < create table #extprops(owner sysname null, objname sysname null, name sysname, value sql_variant null) drop table #extprops   p.name p.value  p.name p.value usrt.xusertype = {0}.xusertype baset.xusertype = {0}.xtype and baset.xusertype = baset.xtype s{0}.uid = usrt.uid usrt.user_type_id = {0}.user_type_id baset.user_type_id = {0}.system_type_id and baset.user_type_id = baset.system_type_id s{0}.schema_id = usrt.schema_id xsc{0}.xml_collection_id = {0}.xml_collection_id s2{0}.schema_id = xsc{0}.schema_id usrt.name s{0}.name ISNULL(baset.name, N'') CASE WHEN baset.name IN (N'char', N'varchar', N'binary', N'varbinary', N'nchar', N'nvarchar') THEN {0}.prec ELSE {0}.length END {0}.xprec {0}.xscale CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND {0}.max_length <> -1 THEN {0}.max_length/2 ELSE {0}.max_length END {0}.precision {0}.scale ISNULL(xsc{0}.name, N'') ISNULL(s2{0}.name, N'') ISNULL( (case {0}.is_xml_document when 1 then 2 else 1 end), 0)  fg{0}.groupname CASE WHEN 'FG'=ds{0}.type THEN ds{0}.name ELSE N'' END CASE WHEN 'PS'=ds{0}.type THEN ds{0}.name ELSE N'' END CASE WHEN 'PS'=ds{0}.type THEN 1 ELSE 0 END  sf.data_space_id = sdd.data_space_id sf.name sdd.destination_id  sps.function_id = spf.function_id sps.name sps.data_space_id spf.name ISNULL((case when spf.fanout < (select count(*) from sys.destination_data_spaces sdd where sps.data_space_id = sdd.partition_scheme_id) then (select sf.name from sys.filegroups sf, sys.destination_data_spaces sdd where sf.data_space_id = sdd.data_space_id and sps.data_space_id = sdd.partition_scheme_id and sdd.destination_id > spf.fanout) else null end),N'')  sprv.boundary_id sprv.value  st.system_type_id = st.user_type_id and spp.system_type_id = st.system_type_id spp.parameter_id ISNULL(spp.collation_name,N'')  spf.name spf.function_id spf.boundary_value_on_right spf.create_date spf.fanout L ic.partition_ordinal > 0 c.object_id = ic.object_id and c.column_id = ic.column_id c.name ic.partition_ordinal  cstr.status & 4 1 - ISNULL(OBJECTPROPERTY(cstr.id, N'CnstIsNotTrusted'),0) 1 - ISNULL(OBJECTPROPERTY(cstr.id, N'CnstIsDisabled'),0) ISNULL(OBJECTPROPERTY(cstr.id, N'CnstIsNotRepl'),0) cstr.is_system_named ~cstr.is_not_trusted ~cstr.is_disabled cstr.is_not_for_replication  CASE WHEN (OBJECTPROPERTY({0}.id, N'IsMSShipped')=1) THEN 1 WHEN 1 = OBJECTPROPERTY({0}.id, N'IsSystemTable') THEN 1 ELSE 0 END case when {0}.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = {0}.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end  CASE WHEN (OBJECTPROPERTY({0}.id, N'IsMSShipped')=1) THEN 1 WHEN 1 = OBJECTPROPERTY({0}.id, N'IsSystemTable') THEN 1 ELSE 0 END {0}.is_ms_shipped  s{0}.uid = {0}.uid s{0}.name SCHEMA_NAME({0}.schema_id)  comt.colid comt.text cast(comt.id as nvarchar(20)) + N'_' + cast(comt.number as nvarchar(20)) + N'_' + cast(db_id() as nvarchar(20)) + N'_0'  cfk.colid=fk.fkey and cfk.id = fk.fkeyid crk.colid=fk.rkey and crk.id = fk.rkeyid fk.parent_column_id = cfk.column_id and fk.parent_object_id = cfk.object_id fk.referenced_column_id = crk.column_id and fk.referenced_object_id = crk.object_id cfk.name fk.keyno crk.name cfk.name fk.constraint_column_id crk.name  declare @NumErrorLogs int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', @NumErrorLogs OUTPUT declare @SmoDefaultFile nvarchar(512) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', @SmoDefaultFile OUTPUT declare @SmoDefaultLog nvarchar(512) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', @SmoDefaultLog OUTPUT declare @SmoLoginMode int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', @SmoLoginMode OUTPUT declare @SmoAuditLevel int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', @SmoAuditLevel OUTPUT declare @SmoTapeLoadWaitTime int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'Tapeloadwaittime', @SmoTapeLoadWaitTime OUTPUT declare @BackupDirectory nvarchar(512) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory', @BackupDirectory OUTPUT declare @SmoMailProfile nvarchar(512) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'MailAccountName', @SmoMailProfile OUTPUT declare @SmoPerfMonMode int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'Performance', @SmoPerfMonMode OUTPUT if @SmoPerfMonMode is null begin set @SmoPerfMonMode = 1000 end declare @NumErrorLogs int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', @NumErrorLogs OUTPUT declare @SmoDefaultFile nvarchar(512) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', @SmoDefaultFile OUTPUT declare @SmoDefaultLog nvarchar(512) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', @SmoDefaultLog OUTPUT declare @SmoLoginMode int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', @SmoLoginMode OUTPUT declare @SmoAuditLevel int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', @SmoAuditLevel OUTPUT declare @SmoTapeLoadWaitTime int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'Tapeloadwaittime', @SmoTapeLoadWaitTime OUTPUT declare @BackupDirectory nvarchar(512) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory', @BackupDirectory OUTPUT declare @SmoMailProfile nvarchar(512) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'MailAccountName', @SmoMailProfile OUTPUT declare @SmoPerfMonMode int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'Performance', @SmoPerfMonMode OUTPUT if @SmoPerfMonMode is null begin set @SmoPerfMonMode = 1000 end @SmoAuditLevel ISNULL(@SmoDefaultFile,N'') ISNULL(@SmoDefaultLog,N'') ISNULL(@NumErrorLogs, -1) (case when @SmoLoginMode < 3 then @SmoLoginMode else 9 end) @SmoTapeLoadWaitTime ISNULL(@SmoMailProfile,N'') @BackupDirectory @SmoPerfMonMode  create table #SVer(ID int, Name sysname, Internal_Value int, Value nvarchar(512)) insert #SVer exec master.dbo.xp_msver declare @NetName sysname exec master.dbo.xp_getnetname @NetName OUTPUT declare @SmoRoot nvarchar(512) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT declare @RegPathParams sysname declare @Arg sysname declare @Param sysname declare @MasterPath nvarchar(512) declare @LogPath nvarchar(512) declare @ErrorLogPath nvarchar(512) declare @n int select @n=0 select @RegPathParams=N'Software\Microsoft\MSSQLServer\MSSQLServer'+'\Parameters' select @Param='dummy' while(not @Param is null) begin select @Param=null select @Arg='SqlArg'+convert(nvarchar,@n) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @RegPathParams, @Arg, @Param OUTPUT if(@Param like '-d%') begin select @Param=substring(@Param, 3, 255) select @MasterPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param))) end else if(@Param like '-l%') begin select @Param=substring(@Param, 3, 255) select @LogPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param))) end else if(@Param like '-e%') begin select @Param=substring(@Param, 3, 255) select @ErrorLogPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param))) end select @n=@n+1 end drop table #SVer create table #SVer(ID int, Name sysname, Internal_Value int, Value nvarchar(512)) insert #SVer exec master.dbo.xp_msver declare @SmoRoot nvarchar(512) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT declare @RegPathParams sysname declare @Arg sysname declare @Param sysname declare @MasterPath nvarchar(512) declare @LogPath nvarchar(512) declare @ErrorLogPath nvarchar(512) declare @n int select @n=0 select @RegPathParams=N'Software\Microsoft\MSSQLServer\MSSQLServer'+'\Parameters' select @Param='dummy' while(not @Param is null) begin select @Param=null select @Arg='SqlArg'+convert(nvarchar,@n) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', @RegPathParams, @Arg, @Param OUTPUT if(@Param like '-d%') begin select @Param=substring(@Param, 3, 255) select @MasterPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param))) end else if(@Param like '-l%') begin select @Param=substring(@Param, 3, 255) select @LogPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param))) end else if(@Param like '-e%') begin select @Param=substring(@Param, 3, 255) select @ErrorLogPath=substring(@Param, 1, len(@Param) - charindex('\', reverse(@Param))) end select @n=@n+1 end drop table #SVer (select Value from #SVer where Name = N'ProductName') (select Value from #SVer where Name = N'WindowsVersion') (select Value from #SVer where Name = N'Language') (select Value from #SVer where Name = N'Platform') (select Internal_Value from #SVer where Name = N'PhysicalMemory') (select Internal_Value from #SVer where Name = N'ProcessorCount') (@@microsoftversion / 0x1000000) & 0xff (@@microsoftversion / 0x10000) & 0xff @@microsoftversion & 0xffff case when 'a' <> 'A' then 1 else 0 end FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') @LogPath @MasterPath @ErrorLogPath @@MAX_PRECISION @SmoRoot (select Value from #SVer where Name = N'ProductVersion') @NetName SUBSTRING(@@version,PATINDEX(N'%Corporation%',@@version)+DATALENGTH('Corporation')+2,PATINDEX(N'% on %',@@version)-(PATINDEX(N'%Corporation%',@@version)+DATALENGTH('Corporation')+2)) SERVERPROPERTY(N'ProductVersion') SERVERPROPERTY(N'MachineName') SERVERPROPERTY(N'Edition') SERVERPROPERTY(N'ProductLevel') SERVERPROPERTY('IsClustered') SERVERPROPERTY('IsSingleUser') SERVERPROPERTY('EngineEdition') case when (select password from master.dbo.syslogins where sid = 0x01) is null then 1 else 0 end null convert(sysname, serverproperty(N'collation')) I declare @UserOption int select @UserOption=c.value from master.dbo.sysconfigures c, master.dbo.spt_values v where v.type = 'C ' and not c.status is null and v.number = c.config and v.name='user options' declare @UserOption int select @UserOption=c.value from sys.sysconfigures c where not c.status is null and c.comment='user options' @UserOption & 1 @UserOption & 2 @UserOption & 4 @UserOption & 8 @UserOption & 16 @UserOption & 32 @UserOption & 64 @UserOption & 128 @UserOption & 256 @UserOption & 512 @UserOption & 1024 @UserOption & 2048 @UserOption & 4096 @UserOption & 8192 @UserOption & 16384  clmns.id = c.id and clmns.colid = c.colid clmns.name c.keyno COL_NAME(sic.object_id, sic.column_id) sic.stats_column_id  convert(nchar(1), am.name)= convert(nchar(1), srddrv.DriveName) create table #avmed (name nvarchar(512), low_free int, high_free int, type int) insert #avmed exec master.dbo.xp_availablemedia update #avmed set name = convert(nchar(2), name) create table #tmpsrdDrive ( DriveName nvarchar(255) ) insert #tmpsrdDrive select * from ::fn_servershareddrives() create table #tmpsrdDrive ( DriveName nvarchar(255) ) insert #tmpsrdDrive select * from sys.fn_servershareddrives() drop table #avmed drop table #tmpsrdDrive am.name am.low_free am.high_free case when am.low_free >= 0 then 0. + am.low_free else 4294967296. + am.low_free end + 4294967296. * am.high_free am.type case when srddrv.DriveName is null then 0 else 1 end drop table #err_log_text_tmp ert.LogDate ert.ErrorLevel ert.Text  create table #err_log_tmp(ArchiveNo int, CreateDate nvarchar(24), Size int) insert #err_log_tmp exec master.dbo.sp_enumerrorlogs 2 create table #err_log_tmp(ArchiveNo int, CreateDate datetime, Size int, ErrorLog NVARCHAR(255)) DECLARE @errorlog_path NVARCHAR(255) DECLARE @errorlog_dir NVARCHAR(255) DECLARE @errorlog_partfile NVARCHAR(255) DECLARE @errorlog NVARCHAR(255) DECLARE @dotIdx INT DECLARE @slashIdx INT DECLARE @logexists INT DECLARE @ArchiveNo INT EXECUTE master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'ErrorLogFile', @errorlog_path OUTPUT, N'no_output' EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'ErrorLogFile', @errorlog_path OUTPUT, N'no_output' --> EXECUTE master.dbo.xp_fileexist @errorlog_path, @logexists OUTPUT IF(@logexists = 1) BEGIN create table #err_logs_dir_tmp(ErrorLog NVARCHAR(255), d int, f int) create table #file_details_tmp(AltName NVARCHAR(32) NULL, Size int, CDate INT, CTime INT, LWDate INT, LWTime INT, LADate INT, LATime INT, Attributes INT) INSERT #file_details_tmp EXECUTE master.dbo.xp_getfiledetails @errorlog_path SET @errorlog_path = REVERSE(@errorlog_path) SET @dotIdx = CHARINDEX(N'.', @errorlog_path); SET @slashIdx = CHARINDEX(N'\', @errorlog_path); SET @errorlog_path = REVERSE(@errorlog_path) SET @errorlog_dir = @errorlog_path if(@slashIdx <> 0) BEGIN SET @errorlog_dir = SUBSTRING(@errorlog_path, 1, LEN(@errorlog_path) - @slashIdx) SET @errorlog_partfile= SUBSTRING(@errorlog_path, LEN(@errorlog_path) - @slashIdx + 2, 255) END if(@dotIdx <> 0) BEGIN SET @errorlog_partfile = SUBSTRING(@errorlog_partfile, 1, LEN(@errorlog_partfile) - @dotIdx + 1) END INSERT #err_logs_dir_tmp EXECUTE master.dbo.xp_dirtree @errorlog_dir, 1, 1 INSERT #err_log_tmp(ArchiveNo, CreateDate, Size, ErrorLog) SELECT 0, -- convert the 2 int's (20020912 152026) to yyyy-mm-dd hh:mi:ss CONVERT(datetime, STUFF(STUFF(STR(LWDate, 8), 7, 0, '-'), 5, 0, '-') + ' ' + STUFF(STUFF(REPLACE(STR(LWTime,6), ' ', '0'), 5, 0, ':'), 3, 0, ':') , 120), Size, @errorlog_path FROM #file_details_tmp DELETE #file_details_tmp declare crslogs insensitive cursor for ( SELECT ErrorLog FROM #err_logs_dir_tmp WHERE ErrorLog like @errorlog_partfile + '[1-9]' ) for read only open crslogs fetch crslogs into @errorlog while @@fetch_status >= 0 begin SET @ArchiveNo = CONVERT(INT, SUBSTRING(@errorlog, LEN(@errorlog_partfile) + 1, 1)) SET @errorlog = @errorlog_dir + '\' + @errorlog INSERT #file_details_tmp EXECUTE master.dbo.xp_getfiledetails @errorlog INSERT #err_log_tmp(ArchiveNo, CreateDate, Size, ErrorLog) SELECT @ArchiveNo, -- convert the 2 int's (20020912 152026) to yyyy-mm-dd hh:mi:ss CONVERT(datetime, STUFF(STUFF(STR(LWDate, 8), 7, 0, '-'), 5, 0, '-') + ' ' + STUFF(STUFF(REPLACE(STR(LWTime,6), ' ', '0'), 5, 0, ':'), 3, 0, ':') , 120), Size, @errorlog FROM #file_details_tmp DELETE #file_details_tmp fetch crslogs into @errorlog end close crslogs deallocate crslogs DROP TABLE #file_details_tmp DROP TABLE #err_logs_dir_tmp END drop table #err_log_tmp er.ArchiveNo er.ArchiveNo er.CreateDate CONVERT(datetime, er.CreateDate, 101) er.Size  drop table #tmp_sp_help_jobserver tshj.server_name tshj.server_id tshj.enlist_date tshj.last_poll_date null tshj.last_run_duration tshj.last_run_outcome tshj.last_outcome_message create table #tmp_sp_help_jobhistory (instance_id int null, job_id uniqueidentifier null, job_name nvarchar(128) null, step_id int null, step_name nvarchar(128) null, sql_message_id int null, sql_severity int null, message nvarchar(1024) null, run_status int null, run_date int null, run_time int null, run_duration int null, operator_emailed nvarchar(128) null, operator_netsent nvarchar(128) null, operator_paged nvarchar(128) null, retries_attempted int null, server nvarchar(30) null) insert into #tmp_sp_help_jobhistory exec msdb.dbo.sp_help_jobhistory @mode='FULL' drop table #tmp_sp_help_jobhistory tshj.instance_id tshj.sql_message_id tshj.message tshj.step_id tshj.step_name tshj.sql_severity tshj.job_id tshj.job_name tshj.run_status convert(datetime, stuff(stuff(cast(tshj.run_date as nchar(8)), 7, 0, '-'), 5, 0, '-') + N' ' + stuff(stuff(substring(cast(1000000 + tshj.run_time as nchar(7)), 2, 6), 5, 0, ':'), 3, 0, ':'), 120) tshj.run_duration tshj.operator_emailed tshj.operator_netsent tshj.operator_paged tshj.retries_attempted tshj.server " & {0}.definition  drop table #tmp_sp_help_targetservergroup_member tshtm.server_name tshtm.server_id  create table #tmp_sp_help_targetservergroup (servergroup_id int null, name nvarchar(128) null) insert into #tmp_sp_help_targetservergroup exec msdb..sp_help_targetservergroup drop table #tmp_sp_help_targetservergroup tsht.name tsht.servergroup_id " declare @FailSafeOperator nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeOperator', @param = @FailSafeOperator OUT, @no_output = N'no_output' declare @NotificationMethod int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertNotificationMethod', @param = @NotificationMethod OUT, @no_output = N'no_output' declare @ForwardingServer nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardingServer', @param = @ForwardingServer OUT, @no_output = N'no_output' declare @ForwardingSeverity int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardingSeverity', @param = @ForwardingSeverity OUT, @no_output = N'no_output' declare @ForwardAlways int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardAlways', @param = @ForwardAlways OUT, @no_output = N'no_output' declare @PagerToTemplate nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerToTemplate', @param = @PagerToTemplate OUT, @no_output = N'no_output' declare @PagerCCTemplate nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerCCTemplate', @param = @PagerCCTemplate OUT, @no_output = N'no_output' declare @PagerSubjectTemplate nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerSubjectTemplate', @param = @PagerSubjectTemplate OUT, @no_output = N'no_output' declare @PagerSendSubjectOnly int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerSendSubjectOnly', @param = @PagerSendSubjectOnly OUT, @no_output = N'no_output' declare @FailSafeEmailAddress nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeEmailAddress', @param = @FailSafeEmailAddress OUT, @no_output = N'no_output' declare @FailSafePagerAddress nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafePagerAddress', @param = @FailSafePagerAddress OUT, @no_output = N'no_output' declare @FailSafeNetSendAddress nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeNetSendAddress', @param = @FailSafeNetSendAddress OUT, @no_output = N'no_output' declare @FailSafeOperator nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeOperator', @param = @FailSafeOperator OUT, @no_output = N'no_output' declare @NotificationMethod int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertNotificationMethod', @param = @NotificationMethod OUT, @no_output = N'no_output' declare @ForwardingServer nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardingServer', @param = @ForwardingServer OUT, @no_output = N'no_output' declare @ForwardingSeverity int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardingSeverity', @param = @ForwardingSeverity OUT, @no_output = N'no_output' declare @ForwardAlways int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertForwardAlways', @param = @ForwardAlways OUT, @no_output = N'no_output' declare @PagerToTemplate nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerToTemplate', @param = @PagerToTemplate OUT, @no_output = N'no_output' declare @PagerCCTemplate nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerCCTemplate', @param = @PagerCCTemplate OUT, @no_output = N'no_output' declare @PagerSubjectTemplate nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerSubjectTemplate', @param = @PagerSubjectTemplate OUT, @no_output = N'no_output' declare @PagerSendSubjectOnly int exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertPagerSendSubjectOnly', @param = @PagerSendSubjectOnly OUT, @no_output = N'no_output' declare @FailSafeEmailAddress nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeEmailAddress', @param = @FailSafeEmailAddress OUT, @no_output = N'no_output' declare @FailSafePagerAddress nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafePagerAddress', @param = @FailSafePagerAddress OUT, @no_output = N'no_output' declare @FailSafeNetSendAddress nvarchar(255) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'AlertFailSafeNetSendAddress', @param = @FailSafeNetSendAddress OUT, @no_output = N'no_output' N'AlertSystem' ISNULL(@FailSafeOperator,N'') @NotificationMethod ISNULL(@ForwardingServer,N'') @ForwardingSeverity ISNULL(@ForwardAlways, 0) ISNULL(@PagerToTemplate,N'') ISNULL(@PagerCCTemplate,N'') ISNULL(@PagerSubjectTemplate,N'') @PagerSendSubjectOnly ISNULL(@FailSafeEmailAddress,N'') ISNULL(@FailSafePagerAddress,N'') ISNULL(@FailSafeNetSendAddress,N'')  create table #tmp_sp_help_targetserver (server_id int null, server_name nvarchar(30) null, location nvarchar(200) null, time_zone_adjustment int null, enlist_date datetime null, last_poll_date datetime null, status int null, unread_instructions int null, local_time datetime null, enlisted_by_nt_user nvarchar(200) null, poll_interval int null) insert into #tmp_sp_help_targetserver exec msdb.dbo.sp_help_targetserver drop table #tmp_sp_help_targetserver tsht.server_name tsht.server_id tsht.location tsht.time_zone_adjustment tsht.enlist_date tsht.last_poll_date tsht.status tsht.poll_interval tsht.unread_instructions tsht.local_time  create table #tmp_sp_help_operator (id int null, name nvarchar(128) null, enabled tinyint null, email_address nvarchar(100) null, last_email_date int null, last_email_time int null, pager_address nvarchar(100) null, last_pager_date int null, last_pager_time int null, weekday_pager_start_time int null, weekday_pager_end_time int null, saturday_pager_start_time int null, saturday_pager_end_time int null, sunday_pager_start_time int null, sunday_pager_end_time int null, pager_days tinyint null, netsend_address nvarchar(100) null, last_netsend_date int null, last_netsend_time int null, category_name nvarchar(128) null) insert into #tmp_sp_help_operator exec msdb.dbo.sp_help_operator drop table #tmp_sp_help_operator tsho.name tsho.id tsho.enabled ISNULL(tsho.email_address,N'') null ISNULL(tsho.pager_address,N'') null 0 0 0 0 0 0 tsho.pager_days ISNULL(tsho.netsend_address,N'') null ISNULL(tsho.category_name,N'') Z create table #tmp_sp_help_alert (id int null, name nvarchar(128) null, event_source nvarchar(100) null, event_category_id int null, event_id int null, message_id int null, severity int null, enabled tinyint null, delay_between_responses int null, last_occurrence_date int null, last_occurrence_time int null, last_response_date int null, last_response_time int null, notification_message nvarchar(512) null, include_event_description tinyint null, database_name nvarchar(128) null, event_description_keyword nvarchar(100) null, occurrence_count int null, count_reset_date int null, count_reset_time int null, job_id uniqueidentifier null, job_name nvarchar(128) null, has_notification int null, flags int null, performance_condition nvarchar(512) null, category_name nvarchar(128) null, type int null) insert into #tmp_sp_help_alert exec msdb.dbo.sp_help_alert create table #tmp_sp_help_alert (id int null, name nvarchar(128) null, event_source nvarchar(100) null, event_category_id int null, event_id int null, message_id int null, severity int null, enabled tinyint null, delay_between_responses int null, last_occurrence_date int null, last_occurrence_time int null, last_response_date int null, last_response_time int null, notification_message nvarchar(512) null, include_event_description tinyint null, database_name nvarchar(128) null, event_description_keyword nvarchar(100) null, occurrence_count int null, count_reset_date int null, count_reset_time int null, job_id uniqueidentifier null, job_name nvarchar(128) null, has_notification int null, flags int null, performance_condition nvarchar(512) null, category_name nvarchar(128) null, wmi_namespace nvarchar(max) null, wmi_query nvarchar(max) null, type int null) insert into #tmp_sp_help_alert exec msdb.dbo.sp_help_alert drop table #tmp_sp_help_alert tsha.id tsha.name ISNULL(tsha.event_source,N'') tsha.message_id tsha.severity tsha.enabled tsha.delay_between_responses null null ISNULL(tsha.notification_message,N'') tsha.include_event_description ISNULL(tsha.database_name,N'') ISNULL(tsha.event_description_keyword,N'') tsha.occurrence_count null ISNULL(tsha.job_id, convert(uniqueidentifier, N'00000000-0000-0000-0000-000000000000')) ISNULL(tsha.job_name,N'') tsha.has_notification ISNULL(tsha.performance_condition,N'') ISNULL(tsha.category_name,N'') ISNULL(tsha.wmi_namespace,N'') ISNULL(tsha.wmi_query,N'') tsha.type  bkpms.media_set_id bkpms.media_uuid bkpms.media_family_count bkpms.name bkpms.description bkpms.software_name bkpms.software_vendor_id bkpms.MTF_major_version  bkpmf.media_family_id bkpmf.family_sequence_number bkpmf.media_count bkpmf.logical_device_name bkpmf.physical_device_name CASE WHEN bkpmf.device_type > 100 THEN bkpmf.device_type - 100 ELSE bkpmf.device_type END CASE WHEN bkpmf.device_type > 100 THEN 1 ELSE 0 END bkpmf.physical_block_size  bkpf.first_family_number bkpf.first_media_number bkpf.filegroup_name bkpf.page_size bkpf.file_number bkpf.backed_up_page_count bkpf.file_type bkpf.source_file_block_size bkpf.file_size bkpf.logical_name bkpf.physical_drive bkpf.physical_name  rtsfg.filegroup_name  rtsf.file_number rtsf.destination_phys_drive rtsf.destination_phys_name  rthist.restore_history_id rthist.restore_date rthist.destination_database_name rthist.user_name rthist.backup_set_id CASE rthist.restore_type WHEN 'D' THEN 1 WHEN 'F' THEN 2 WHEN 'L' THEN 3 WHEN 'V' THEN 4 END rthist.replace rthist.recovery rthist.restart rthist.stop_at rthist.device_count rthist.stop_at_mark_name rthist.stop_before O bkps.name bkps.backup_set_id bkps.backup_set_uuid bkps.media_set_id bkps.first_family_number bkps.first_media_number bkps.last_family_number bkps.last_media_number bkps.catalog_family_number bkps.catalog_media_number bkps.position bkps.expiration_date bkps.software_vendor_id bkps.description bkps.user_name bkps.software_major_version bkps.software_minor_version bkps.software_build_version bkps.time_zone bkps.mtf_minor_version bkps.first_lsn bkps.last_lsn bkps.checkpoint_lsn bkps.database_backup_lsn bkps.database_creation_date bkps.backup_start_date bkps.backup_finish_date CASE bkps.type WHEN 'D' THEN 1 WHEN 'I' THEN 2 WHEN 'L' THEN 3 WHEN 'F' THEN 4 END bkps.sort_order bkps.code_page bkps.compatibility_level bkps.database_version bkps.backup_size bkps.database_name bkps.server_name bkps.machine_name bkps.flags bkps.unicode_locale bkps.unicode_compare_style bkps.collation_name bkps.is_password_protected  DECLARE @PageSize float SELECT @PageSize=v.low/1024.0 FROM master..spt_values v WHERE v.number=1 AND v.type='E' rtrim(s.name) s.fileid rtrim(s.filename) (s.size * @PageSize) case when s.maxsize=-1 then -1 else s.maxsize * @PageSize end CASE WHEN (0 <>(s.status & 0x100000)) THEN s.growth ELSE s.growth * @PageSize END CASE WHEN s.growth=0 THEN 99 WHEN (0 <>(s.status & 0x100000)) THEN 1 ELSE 0 END s.name s.file_id s.physical_name s.size * CONVERT(float,8) CASE when s.max_size=-1 then -1 else s.max_size * CONVERT(float,8) END CASE s.is_percent_growth WHEN 1 THEN s.growth ELSE s.growth*8 END CASE when s.growth=0 THEN 99 ELSE s.is_percent_growth END s.is_media_read_only s.is_read_only case s.state when 6 then 1 else 0 end s.is_sparse  NULL NULL NULL  create table #tpdv ( Name nvarchar(512) NOT NULL) insert #tpdv (Name) EXECUTE master.dbo.xp_get_tape_devices drop table #tpdv Name  v.number = l.mode AND v.type = N'L' v2.number = l.ltype AND v2.type = N'LR' CREATE TABLE #t(spid int, mode int, dbid int NULL, objid int, objid2 int, indid int, status tinyint, ltype tinyint, objname sysname NULL, indname sysname NULL, dbname sysname NULL, sch sysname NULL) INSERT #t SELECT spid = req_spid, mode = req_mode, dbid=rsc_dbid, objid=l.rsc_objid, objid2=l.rsc_objid, indid=l.rsc_indid, status = l.req_status, ltype = l.rsc_type, objname=NULL, indname=NULL, dbname = NULL, sch = NULL FROM master.dbo.syslockinfo l WHERE rsc_dbid != db_id('tempdb') OR rsc_objid != object_id('#t') update #t set dbname = d.name FROM #t t LEFT OUTER JOIN master.dbo.sysdatabases d ON d.dbid = t.dbid update #t set dbname = d.name FROM #t t LEFT OUTER JOIN sys.databases d ON d.database_id = t.dbid update #t set objid2 = -objid2 where dbname is null DECLARE name_cursor CURSOR FOR select t.dbid, t.dbname FROM #t t GROUP BY t.dbid, t.dbname OPEN name_cursor DECLARE @dbid int DECLARE @dbname sysname DECLARE @sql nvarchar(1000) FETCH NEXT FROM name_cursor INTO @dbid, @dbname WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN SELECT @sql = 'use ' + quotename(@dbname) + ' update #t set objname = o.name, indname = i.name, sch=user_name(o.uid) FROM #t AS t '+ 'LEFT JOIN dbo.sysobjects AS o ON o.id = t.objid LEFT OUTER JOIN dbo.sysindexes AS i ON i.id = t.objid AND i.indid = t.indid '+ 'WHERE t.ltype in (4,5) AND t.dbid = ' + CAST(@dbid AS NVARCHAR(20)) IF( NOT @dbname IS NULL )--resource database SELECT @sql = 'use ' + quotename(@dbname) ELSE SELECT @sql = '' SELECT @sql = @sql + ' update #t set objname = o.name, indname = i.name, sch=schema_name(o.schema_id) FROM #t AS t '+ 'LEFT JOIN sys.all_objects AS o ON o.object_id = t.objid2 LEFT OUTER JOIN sys.indexes AS i ON i.object_id = t.objid2 AND i.index_id = t.indid '+ 'WHERE t.ltype in (4,5) AND t.dbid = ' + CAST(@dbid AS NVARCHAR(20)) EXEC(@sql) END FETCH NEXT FROM name_cursor INTO @dbid, @dbname END CLOSE name_cursor DEALLOCATE name_cursor drop table #t l.spid v.name l.dbname l.sch l.objname l.indname l.status d r.session_id = p.session_id pr.spid = p.session_id p.spid p.spid suser_sname(p.sid) p.hostname p.status p.cmd db_name(p.dbid) p.cpu p.memusage p.blocked case when p.spid < 51 then 1 else 0 end p.session_id p.session_id p.login_name p.host_name r.status r.command db_name(r.database_id) p.cpu_time p.memory_usage r.blocking_session_id ~p.is_user_process p.program_name 0 p.ecid pr.ecid  create table #err_log_text_tmp_final(Text nvarchar(4000), ArchiveNo int null, LogDate datetime null, ProcessInfo nvarchar(100) null) declare @text_offset int declare @process_info_length int set @text_offset = 34 set @process_info_length = 10 drop table #err_log_text_tmp_final ert.LogDate ert.ProcessInfo ert.Text S create table #err_log_tmp(ArchiveNo int, CreateDate nvarchar(24)) create table #err_log_tmp(ArchiveNo int, CreateDate nvarchar(24), Size int) insert #err_log_tmp exec master.dbo.sp_enumerrorlogs drop table #err_log_tmp er.ArchiveNo er.ArchiveNo CONVERT(datetime, er.CreateDate, 101) er.Size " l.req_mode = v.number and v.type = N'L' and db_id() = l.rsc_dbid l.req_spid v.name db_name(l.rsc_dbid) object_name(l.rsc_objid) object_name(l.rsc_indid) l.req_status r cl.name COLLATIONPROPERTY(name, 'CodePage') COLLATIONPROPERTY(name, 'LCID') COLLATIONPROPERTY(name, 'ComparisonStyle') cl.description 0 (st.indid <> 0 and st.indid <> 255) and 0 = OBJECTPROPERTY(st.id,N'IsMSShipped') st.name st.indid case when (st.status & 16777216) <> 0 then 1 else 0 end STATS_DATE(st.id, st.indid) 1 - INDEXPROPERTY(st.id,st.name,N'IsStatistics') INDEXPROPERTY(st.id,st.name,N'IsAutoStatistics') '' st.stats_id st.no_recompute STATS_DATE(st.object_id, st.stats_id) 1 - INDEXPROPERTY(st.object_id,st.name,N'IsStatistics') st.auto_created '' null m c.colid case when c.number > 1 then c.number else 0 end c.text cast(c.id as nvarchar(20)) + N'_' + cast(db_id() as nvarchar(20)) + N'_' + cast(case when c.number > 1 then c.number else 0 end as nvarchar(20)) + cstr.xtype='D' and cstr.name not like N'#%%' and 0!=convert(bit,cstr.category & 0x0800) Q   Q  OBJECTPROPERTY({0}.id,N'ExecIsAnsiNullsOn') OBJECTPROPERTY({0}.id,N'ExecIsQuotedIdentOn') OBJECTPROPERTY({0}.id, N'IsSchemaBound') (SELECT TOP 1 encrypted FROM dbo.syscomments p WHERE {0}.id = p.id AND p.colid=1 and p.number < 2) {0}.status & 4 CASE WHEN ISNULL({0}.definition, s{0}.definition) IS NULL THEN 1 ELSE 0 END ISNULL({0}.is_recompiled, s{0}.is_recompiled)   ~  xproc.xtype='X' xproc.type='X' >  (o.status & 0x10) <> 0 o.name o.phyname o.cntrltype o.status & 0x08 st.xusertype = st.xtype or st.name=N'sysname' st.schema_id=4 CASE WHEN st.name IN (N'decimal', N'numeric') THEN 1 ELSE 0 END CASE WHEN st.name IN ( N'varchar', N'varbinary', N'nvarchar' ) THEN 1 ELSE 0 END CASE WHEN st.name IN (N'decimal', N'int', N'numeric', N'smallint', N'tinyint', N'bigint') THEN 1 ELSE 0 END CASE WHEN st.name IN ( N'char', N'varchar', N'binary', N'varbinary', N'nchar', N'nvarchar' ) THEN 1 ELSE 0 END st.allownulls CASE WHEN st.name IN (N'char', N'varchar', N'binary', N'varbinary', N'nchar', N'nvarchar') THEN st.prec ELSE st.length END st.xprec st.xscale ISNULL(st.collation,N'') st.is_nullable CASE WHEN st.name IN (N'nchar', N'nvarchar') THEN st.max_length/2 ELSE st.max_length END ISNULL(st.collation_name,N'') st.user_type_id st.precision st.scale  @@OPTIONS & 1 @@OPTIONS & 2 @@OPTIONS & 4 @@OPTIONS & 8 @@OPTIONS & 16 @@OPTIONS & 32 @@OPTIONS & 64 @@OPTIONS & 128 @@OPTIONS & 256 @@OPTIONS & 512 @@OPTIONS & 1024 @@OPTIONS & 2048 @@OPTIONS & 4096 @@OPTIONS & 8192 @@OPTIONS & 16384  t.id = c.id and t.type = 'U' t.object_id = c.object_id c.name t.name user_name(t.uid) schema_name(t.schema_id)  param.number = 1 or (param.number = 0 and 1 = OBJECTPROPERTY(param.id, N'IsScalarFunction') and isnull(param.name, '') != '') param.is_output = 0 cstr.type=N'F' rfr.constid = cstr.id ki.indid = rfr.rkeyindid AND ki.id = rfr.rkeyid rfr.rkeyid = rtbl.id ki.index_id = cstr.key_index_id and ki.object_id = cstr.referenced_object_id rtbl.object_id = cstr.referenced_object_id ki.name rtbl.name user_name(rtbl.uid) OBJECTPROPERTY(cstr.id, N'CnstIsDeleteCascade') OBJECTPROPERTY(cstr.id, N'CnstIsUpdateCascade') ki.name rtbl.name schema_name(rtbl.schema_id) cstr.delete_referential_action cstr.update_referential_action  st.xusertype != st.xtype and st.name != N'sysname' def.id = st.tdefault rul.id = st.domain st.schema_id!=4 and st.system_type_id!=240 and st.user_type_id != st.system_type_id def.object_id = st.default_object_id rul.object_id = st.rule_object_id st.xusertype st.user_type_id st.length st.allownulls st.variable (case when st.tdefault = 0 then N'' else def.name end) (case when st.tdefault = 0 then N'' else user_name(def.uid) end) (case when st.domain = 0 then N'' else rul.name end) (case when st.domain = 0 then N'' else user_name(rul.uid) end) st.collation st.max_length st.is_nullable (case when st.default_object_id = 0 then N'' else def.name end) (case when st.default_object_id = 0 then N'' else schema_name(def.schema_id) end) (case when st.rule_object_id = 0 then N'' else rul.name end) (case when st.rule_object_id = 0 then N'' else schema_name(rul.schema_id) end) st.collation_name CASE WHEN baset.name IN ( N'varchar', N'varbinary', N'nvarchar' ) THEN 1 ELSE 0 END  obj.xtype=N'D' and obj.name not like N'#%%' and 0=(obj.category & 0x0800) obj.type=N'D' and not(obj.parent_object_id > 0)  v.type = 'C ' and not cfg.status is null and v.number = cfg.config ucfg.config = cfg.config v.name v.number v.low v.high cfg.status & 1 cfg.status & 2 ucfg.value cfg.value cfg.comment cfg.name cfg.configuration_id cfg.minimum cfg.maximum cfg.is_dynamic cfg.is_advanced cfg.value cfg.value_in_use cfg.description  p j obj.xtype=N'R' obj.type=N'R' and (0 = obj.parent_object_id or obj.parent_object_id is null) f create table #tmpntlogin ( [Account name] sysname NULL, Type sysname NULL, [Privilege] sysname NULL, [Mapped login name] sysname NULL, [Permission path] sysname NULL) insert into #tmpntlogin exec master.dbo.xp_logininfo drop table #tmpntlogin [Account name] Type [Privilege] [Mapped login name] [Permission path]  drop table #tmpntgrp t.name t.description  'Server[@Name=' + quotename(@@SERVERNAME,'''') + ']/Database[@Name=' + quotename(db_name(),'''') + ']/' + (case when (uob.sysstat & 0xf) = 0 then 'UserDefinedFunction' when (uob.sysstat & 0xf) = 1 or (uob.sysstat & 0xf) = 3 then 'Table' when (uob.sysstat & 0xf) = 2 then 'View' when (uob.sysstat & 0xf) = 4 then 'StoredProcedure' when (uob.sysstat & 0xf) = 6 then 'Default' when (uob.sysstat & 0xf) = 7 then 'Rule' when (uob.sysstat & 0xf) = 8 then 'Trigger' when (uob.sysstat & 0xf) = 9 then 'PrimaryKey' when (uob.sysstat & 0xf) = 10 then 'Check' when (uob.sysstat & 0xf) = 11 then 'ForeignKey' when (uob.sysstat & 0xf) = 12 then 'UserDefinedDataType' else 'Unknown' end) + '[@Name='+quotename(uob.name,'''')+']' 'Server[@Name=' + quotename(cast(serverproperty(N'Servername') as sysname),'''') + ']/Database[@Name=' + quotename(db_name(),'''') + ']/' + (case when (uob.sysstat & 0xf) = 0 then 'UserDefinedFunction' when (uob.sysstat & 0xf) = 1 or (uob.sysstat & 0xf) = 3 then 'Table' when (uob.sysstat & 0xf) = 2 then 'View' when (uob.sysstat & 0xf) = 4 then 'StoredProcedure' when (uob.sysstat & 0xf) = 6 then 'Default' when (uob.sysstat & 0xf) = 7 then 'Rule' when (uob.sysstat & 0xf) = 8 then 'Trigger' when (uob.sysstat & 0xf) = 9 then 'PrimaryKey' when (uob.sysstat & 0xf) = 10 then 'Check' when (uob.sysstat & 0xf) = 11 then 'ForeignKey' when (uob.sysstat & 0xf) = 12 then 'UserDefinedDataType' else 'Unknown' end) + '[@Name='+quotename(uob.name,'''')+']' uob.name uob.id user_name(uob.uid) uob.crdate (uob.sysstat & 0xf) / u.uid = m.id drop table #tmp_role_member_ids u.principal_id = m.id drop table #tmp_role_member_ids u.name u.uid suser_sname(u.sid) u.principal_id suser_sname(u.sid)  declare @Arg sysname declare @Param sysname declare @n int select @n=0 select @Param='dummy' create table #srvargs (value nvarchar(512) NOT NULL) while(not @Param is null) begin select @Param=null select @Arg='SqlArg'+convert(nvarchar,@n) exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer\Parameters', @Arg, @Param OUTPUT exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer\Parameters', @Arg, @Param OUTPUT insert #srvargs select @Param where not @Param is null select @n=@n+1 end drop table #srvargs arg.value ~ sv.category_id = tshc.category_id tsho_e.id = sv.notify_email_operator_id tsho_ns.id = sv.notify_netsend_operator_id tsho_p.id = sv.notify_page_operator_id create table #tmp_sp_help_category (category_id int null, category_type tinyint null, name nvarchar(128) null) insert into #tmp_sp_help_category exec msdb.dbo.sp_help_category create table #tmp_sp_help_operator (id int null, name nvarchar(128) null, enabled tinyint null, email_address nvarchar(100) null, last_email_date int null, last_email_time int null, pager_address nvarchar(100) null, last_pager_date int null, last_pager_time int null, weekday_pager_start_time int null, weekday_pager_end_time int null, saturday_pager_start_time int null, saturday_pager_end_time int null, sunday_pager_start_time int null, sunday_pager_end_time int null, pager_days tinyint null, netsend_address nvarchar(100) null, last_netsend_date int null, last_netsend_time int null, category_name nvarchar(128) null) insert into #tmp_sp_help_operator exec msdb.dbo.sp_help_operator drop table #tmp_sp_help_operator drop table #tmp_sp_help_category sv.name sv.job_id sv.originating_server sv.enabled ISNULL(sv.description,N'') sv.start_step_id ISNULL(suser_sname(sv.owner_sid), N'') sv.notify_level_eventlog sv.notify_level_email sv.notify_level_netsend sv.notify_level_page sv.delete_level sv.date_created sv.date_modified sv.version_number tshc.name ISNULL(tsho_e.name,N'') ISNULL(tsho_ns.name,N'') ISNULL(tsho_p.name,N'') null null null null null null null null null null null % ik.id = clmns.id and 0 != ik.status & 0x0800 cik.indid = ik.indid and cik.colid = clmns.colid and cik.id = clmns.id d.id = clmns.cdefault and 0=d.category & 0x0800 r.id = clmns.domain ic.object_id = clmns.object_id and ic.column_id = clmns.column_id cc.object_id = clmns.object_id and cc.column_id = clmns.column_id ik.object_id = clmns.object_id and 1=ik.is_primary_key cik.index_id = ik.index_id and cik.column_id = clmns.column_id and cik.object_id = clmns.object_id and 0 = cik.is_included_column d.object_id = clmns.default_object_id r.object_id = clmns.rule_object_id clmns.name clmns.colid clmns.isnullable clmns.iscomputed ISNULL(cik.colid, 0) COLUMNPROPERTY(clmns.id, clmns.name, N'UsesAnsiTrim') clmns.colstat & 2 clmns.colstat & 8 COLUMNPROPERTY(clmns.id, clmns.name, N'IsFulltextIndexed') cast(clmns.id as nvarchar(20)) + '_' + cast(clmns.colid as nvarchar(20)) + '_' + cast(db_id() as nvarchar(20)) + '_0' COLUMNPROPERTY(clmns.id, clmns.name, N'IsIdentity') ISNULL((select top 1 1 from dbo.sysforeignkeys AS colfk where colfk.fkey = clmns.colid and colfk.fkeyid = clmns.id), 0) ISNULL(clmns.collation, N'') (case when clmns.cdefault = 0 then N'' else d.name end) (case when clmns.cdefault = 0 then N'' else user_name(d.uid) end) (case when clmns.domain = 0 then N'' else r.name end) (case when clmns.domain = 0 then N'' else user_name(r.uid) end) clmns.name clmns.column_id clmns.is_nullable clmns.is_computed ISNULL(cik.index_column_id, 0) clmns.is_ansi_padded clmns.is_rowguidcol ISNULL(ic.is_not_for_replication, 0) COLUMNPROPERTY(clmns.object_id, clmns.name, N'IsFulltextIndexed') ISNULL(cc.definition,N'') ISNULL(cc.is_persisted, 0) ISNULL(clmns.collation_name, N'') ISNULL((select TOP 1 1 from sys.foreign_key_columns AS colfk where colfk.parent_column_id = clmns.column_id and colfk.parent_object_id = clmns.object_id), 0) clmns.is_identity ISNULL(ic.seed_value,0) ISNULL(ic.increment_value,0) (case when clmns.default_object_id = 0 then N'' when d.parent_object_id > 0 then N'' else d.name end) (case when clmns.default_object_id = 0 then N'' when d.parent_object_id > 0 then N'' else schema_name(d.schema_id) end) (case when clmns.rule_object_id = 0 then N'' else r.name end) (case when clmns.rule_object_id = 0 then N'' else schema_name(r.schema_id) end) r udf.xtype in ( 'TF', 'FN', 'IF') and udf.name not like N'#%%' ret_param.id = udf.id and ret_param.number = 0 and ret_param.name='' udf.type in ('TF', 'FN', 'IF', 'FS', 'FT') ret_param.object_id = udf.object_id and ret_param.is_output = 1 OBJECTPROPERTY(udf.id, N'IsDeterministic') (case when 1 = OBJECTPROPERTY(udf.id, N'IsScalarFunction') then 1 when 1 = OBJECTPROPERTY(udf.id, N'IsInlineFunction') then 3 when 1 = OBJECTPROPERTY(udf.id, N'IsTableFunction') then 2 else 0 end) 1 OBJECTPROPERTYEX(udf.object_id, N'IsDeterministic') (case when 'FN' = udf.type then 1 when 'FS' = udf.type then 1 when 'IF' = udf.type then 3 when 'TF' = udf.type then 2 when 'FT' = udf.type then 2 else 0 end) CASE WHEN udf.type IN ('FN','IF','TF') THEN 1 WHEN udf.type IN ('FS','FT') THEN 2 ELSE 1 END ret_param.name  tr.type = 'TR' tr.type in ('TR', 'TA') trr.object_id = tr.object_id tei.object_id = tr.object_id and tei.type=1 teu.object_id = tr.object_id and teu.type=2 ted.object_id = tr.object_id and ted.type=3 mod.object_id = tr.object_id asmbl.assembly_id = mod.assembly_id 1-OBJECTPROPERTY(tr.id,N'ExecIsTriggerDisabled') OBJECTPROPERTY(tr.id, N'ExecIsInsteadOfTrigger') OBJECTPROPERTY(tr.id,N'ExecIsInsertTrigger') CASE WHEN OBJECTPROPERTY(tr.id, N'ExecIsFirstInsertTrigger') = 1 THEN 0 WHEN OBJECTPROPERTY(tr.id, N'ExecIsLastInsertTrigger') = 1 THEN 2 ELSE 1 END OBJECTPROPERTY(tr.id,N'ExecIsUpdateTrigger') CASE WHEN OBJECTPROPERTY(tr.id, N'ExecIsFirstUpdateTrigger') = 1 THEN 0 WHEN OBJECTPROPERTY(tr.id, N'ExecIsLastUpdateTrigger') = 1 THEN 2 ELSE 1 END OBJECTPROPERTY(tr.id,N'ExecIsDeleteTrigger') CASE WHEN OBJECTPROPERTY(tr.id, N'ExecIsFirstDeleteTrigger') = 1 THEN 0 WHEN OBJECTPROPERTY(tr.id, N'ExecIsLastDeleteTrigger') = 1 THEN 2 ELSE 1 END OBJECTPROPERTY(tr.id,N'ExecIsTriggerNotForRepl') 1 ~trr.is_disabled trr.is_instead_of_trigger ISNULL(tei.object_id,0) CASE WHEN tei.is_first = 1 THEN 0 WHEN tei.is_last = 1 THEN 2 ELSE 1 END ISNULL(teu.object_id,0) CASE WHEN teu.is_first = 1 THEN 0 WHEN teu.is_last = 1 THEN 2 ELSE 1 END ISNULL(ted.object_id,0) CASE WHEN ted.is_first = 1 THEN 0 WHEN ted.is_last = 1 THEN 2 ELSE 1 END trr.is_not_for_replication CASE WHEN tr.type = N'TR' THEN 1 WHEN tr.type = N'TA' THEN 2 ELSE 1 END  cstr.type = 'C' a @@SERVERNAME serverproperty(N'Servername') ISNULL(serverproperty(N'instancename'),N'')  declare @command nvarchar(300) select @command = 'dbcc checkprimaryfile (N''' + @fileName + ''' , 3)' create table #SmoPrimayChildren(status INT,fileid INT,name sysname,filename nvarchar(512)) insert #SmoPrimayChildren exec (@command) drop table #SmoPrimayChildren s.name s.fileid case when (s.status & 0x40) = 0 then 1 else 0 end RTRIM(s.filename) " drop table #OLEDBProvProp prop.Name prop.ID prop.Description prop.Flags 1 create table #OLEDBProv ( Name sysname NOT NULL, ParseName sysname NOT NULL,Description sysname NOT NULL ) insert #OLEDBProv EXECUTE master.dbo.xp_enum_oledb_providers drop table #OLEDBProv op.Name op.ParseName op.Description d declare @command nvarchar(300) select @command = 'dbcc checkprimaryfile (N'''+ @fileName + ''' , 2)' create table #smoPrimaryFileProp(property sql_variant NULL, value sql_variant NULL) insert #smoPrimaryFileProp exec (@command) drop table #smoPrimaryFileProp rtrim(@fileName) p.property p.value p sjs.name sjs.schedule_id sjs.date_created convert(bit,sjs.enabled) sjs.freq_type sjs.freq_interval sjs.freq_subday_type sjs.freq_subday_interval sjs.freq_relative_interval sjs.freq_recurrence_factor cast(null as datetime) 0 cast(null as datetime) 0 (SELECT COUNT(*) FROM msdb.dbo.sysjobschedules as js WHERE (js.schedule_id = sjs.schedule_id))  create table #tmp_sp_help_schedule (schedule_id int null, schedule_uid uniqueidentifier null, schedule_name nvarchar(128) null, enabled int null, freq_type int null, freq_interval int null, freq_subday_type int null, freq_subday_interval int null, freq_relative_interval int null, freq_recurrence_factor int null, active_start_date int null, active_end_date int null, active_start_time int null, active_end_time int null, date_created datetime null, schedule_description nvarchar(4000) null, job_count int null) insert into #tmp_sp_help_schedule exec msdb.dbo.sp_help_schedule drop table #tmp_sp_help_schedule tshs.schedule_name tshs.schedule_id tshs.date_created tshs.enabled tshs.freq_type tshs.freq_interval tshs.freq_subday_type tshs.freq_subday_interval tshs.freq_relative_interval tshs.freq_recurrence_factor null 0 0 null tshs.job_count  drop table #tmp_sp_help_jobschedule tshj.schedule_name tshj.schedule_id tshj.date_created tshj.enabled tshj.freq_type tshj.freq_interval tshj.freq_subday_type tshj.freq_subday_interval tshj.freq_relative_interval tshj.freq_recurrence_factor null 0 0 null (SELECT COUNT(*) FROM msdb.dbo.sysjobschedules as js WHERE (js.schedule_id = tshj.schedule_id)) tshj.job_count  drop table #jobstep_outputlog_tmp tjsol.job_id tjsol.job_name tjsol.step_id tjsol.step_name tjsol.step_uid tjsol.date_created tjsol.date_modified tjsol.log_size tjsol.log  sp.proxy_id = tshj.proxy_id create table #tmp_sp_help_proxy (proxy_id int null, name nvarchar(300) null, credential_identity nvarchar(300) null, enabled tinyint null, description nvarchar(max) null, user_sid binary(200) null, credential_id int null, credential_identity_exists int null) insert into #tmp_sp_help_proxy(proxy_id, name, credential_identity, enabled, description, user_sid, credential_id, credential_identity_exists) exec msdb.dbo.sp_help_proxy drop table #tmp_sp_help_proxy drop table #tmp_sp_help_jobstep tshj.step_name tshj.step_id CASE LOWER(tshj.subsystem) when 'tsql' THEN 1 WHEN 'activescripting' THEN 2 WHEN 'cmdexec' THEN 3 WHEN 'snapshot' THEN 4 WHEN 'logreader' THEN 5 WHEN 'distribution' THEN 6 WHEN 'merge' THEN 7 WHEN 'queuereader' THEN 8 WHEN 'analysisquery' THEN 9 WHEN 'analysiscommand' THEN 10 WHEN 'dts' THEN 11 WHEN 'ssis' THEN 11 ELSE 0 END ISNULL(tshj.command,N'') ISNULL(tshj.command,N'') tshj.cmdexec_success_code tshj.on_success_action tshj.on_success_step_id tshj.on_fail_action tshj.on_fail_step_id ISNULL(tshj.server,N'') ISNULL(tshj.database_name,N'') ISNULL(tshj.database_user_name,N'') tshj.retry_attempts tshj.retry_interval tshj.os_run_priority ISNULL(tshj.output_file_name,N'') tshj.last_run_outcome tshj.last_run_duration tshj.last_run_retries null tshj.flags ISNULL(sp.name,N'') clmns.id = ic.id and clmns.colid = ic.colid and clmns.number = 0 ic.column_id > 0 and (ic.key_ordinal > 0 or ic.partition_ordinal = 0) clmns.object_id = ic.object_id and clmns.column_id = ic.column_id clmns.name ic.keyno COLUMNPROPERTY(ic.id, clmns.name, N'IsComputed') INDEXKEY_PROPERTY(ic.id, ic.indid, ic.keyno, N'IsDescending') clmns.name (case ic.key_ordinal when 0 then cast(1 as tinyint) else ic.key_ordinal end) COLUMNPROPERTY(ic.object_id, clmns.name, N'IsComputed') ic.is_descending_key ic.is_included_column L$ i.indid > 0 and i.indid < 255 and 1 != INDEXPROPERTY(i.id,i.name,N'IsStatistics') and 1 != INDEXPROPERTY(i.id,i.name,N'IsHypothetical') k.parent_obj = i.id AND k.name = i.name AND k.xtype IN (N'PK', N'UQ') i.index_id > 0 and i.is_hypothetical = 0 s.stats_id = i.index_id AND s.object_id = i.object_id k.parent_object_id = i.object_id AND k.unique_index_id = i.index_id xi.object_id = i.object_id AND xi.index_id = i.index_id xi2.object_id = xi.object_id AND xi2.index_id = xi.using_xml_index_id declare @PageSize float select @PageSize=v.low/1024.0 from master.dbo.spt_values v where v.number=1 and v.type='E' i.name i.indid OBJECTPROPERTY(i.id,N'IsMSShipped') INDEXPROPERTY(i.id,i.name,N'IsFulltextKey') CASE WHEN (i.status & 0x1000000) <> 0 THEN 1 ELSE 0 END INDEXPROPERTY(i.id,i.name,N'IndexFillFactor') CASE WHEN (i.indid = 1) THEN (i.used - i.dpages - ISNULL((SELECT SUM(j.used) FROM dbo.sysindexes AS j WHERE (j.indid > 1) AND (j.indid < 255) AND (j.id = i.id) AND (j.name = i.name)), 0)) * @PageSize ELSE i.used * @PageSize END CASE i.indid WHEN 1 THEN 1 ELSE 0 END CASE WHEN 0 != i.status&0x800 THEN 1 WHEN 0 != i.status&0x1000 THEN 2 ELSE 0 END i.status&2 CASE WHEN 0 != (i.status&0x01) THEN 1 ELSE 0 END INDEXPROPERTY(i.id, i.name, N'IsRowLockDisallowed') INDEXPROPERTY(i.id, i.name, N'IsPageLockDisallowed') INDEXPROPERTY(i.id, i.name, N'IsPadIndex') ISNULL(k.status & 4, 0) i.name i.index_id OBJECTPROPERTY(i.object_id,N'IsMSShipped') INDEXPROPERTY(i.object_id,i.name,N'IsFulltextKey') s.no_recompute i.fill_factor ISNULL((select @PageSize * SUM(a.used_pages - CASE WHEN a.type <> 1 THEN a.used_pages WHEN p.index_id < 2 THEN a.data_pages ELSE 0 END) FROM sys.partitions as p JOIN sys.allocation_units as a ON a.container_id = p.partition_id WHERE p.object_id = i.object_id AND p.index_id = i.index_id),0.0) CASE i.index_id WHEN 1 THEN 1 ELSE 0 END i.is_primary_key + 2*i.is_unique_constraint i.is_unique i.ignore_dup_key ~i.allow_row_locks ~i.allow_page_locks INDEXPROPERTY(i.object_id, i.name, N'IsPadIndex') i.is_disabled case when i.type=3 then 1 else 0 end case UPPER(ISNULL(xi.secondary_type,'')) when 'P' then 1 when 'V' then 2 when 'R' then 3 else 0 end ISNULL(xi2.name, N'') ISNULL(k.is_system_named, 0) ) create table #tmp_sp_get_sqlagent_properties (auto_start int null, msx_server_name sysname null, sqlagent_type int null, startup_account nvarchar(255) null, sqlserver_restart int null, jobhistory_max_rows int null, jobhistory_max_rows_per_job int null, errorlog_file nvarchar(255) null, errorlogging_level int null, error_recipient nvarchar(30) null, monitor_autostart int null, local_host_server sysname null, job_shutdown_timeout int null, cmdexec_account varbinary(64) null, regular_connections int null, host_login_name nvarchar(128) null, host_login_password varbinary(512) null, login_timeout int null, idle_cpu_percent int null, idle_cpu_duration int null, oem_errorlog int null, sysadmin_only int null, email_profile nvarchar(64) null, email_save_in_sent_folder int null, cpu_poller_enabled int null) insert into #tmp_sp_get_sqlagent_properties(auto_start, msx_server_name, sqlagent_type, startup_account, sqlserver_restart, jobhistory_max_rows, jobhistory_max_rows_per_job, errorlog_file, errorlogging_level, error_recipient, monitor_autostart, local_host_server, job_shutdown_timeout, cmdexec_account, regular_connections, host_login_name, host_login_password, login_timeout, idle_cpu_percent, idle_cpu_duration, oem_errorlog, sysadmin_only, email_profile, email_save_in_sent_folder, cpu_poller_enabled) exec msdb.dbo.sp_get_sqlagent_properties create table #tmpMsxAccountName ( domain nvarchar(255) null, username nvarchar(255) null) if ( ( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 760) ) or (@@microsoftversion / power(2, 24) > 8)) begin insert into #tmpMsxAccountName(domain, username) exec master.dbo.xp_sqlagent_msx_account N'GET' end create table #tmp_sp_get_sqlagent_properties (auto_start int null, msx_server_name sysname null, sqlagent_type int null, startup_account nvarchar(255) null, sqlserver_restart int null, jobhistory_max_rows int null, jobhistory_max_rows_per_job int null, errorlog_file nvarchar(255) null, errorlogging_level int null, error_recipient nvarchar(30) null, monitor_autostart int null, local_host_server sysname null, job_shutdown_timeout int null, cmdexec_account varbinary(64) null, regular_connections int null, host_login_name nvarchar(128) null, host_login_password varbinary(512) null, login_timeout int null, idle_cpu_percent int null, idle_cpu_duration int null, oem_errorlog int null, sysadmin_only int null, email_profile nvarchar(64) null, email_save_in_sent_folder int null, cpu_poller_enabled int null, replace_alert_tokens_enabled int null) insert into #tmp_sp_get_sqlagent_properties(auto_start, msx_server_name, sqlagent_type, startup_account, sqlserver_restart, jobhistory_max_rows, jobhistory_max_rows_per_job, errorlog_file, errorlogging_level, error_recipient, monitor_autostart, local_host_server, job_shutdown_timeout, cmdexec_account, regular_connections, host_login_name, host_login_password, login_timeout, idle_cpu_percent, idle_cpu_duration, oem_errorlog, sysadmin_only, email_profile, email_save_in_sent_folder, cpu_poller_enabled, replace_alert_tokens_enabled) exec msdb.dbo.sp_get_sqlagent_properties create table #tmpMsxAccountName (msx_connection int null, msx_credential_id int null, msx_credential_name nvarchar(300) null, msx_login_name nvarchar(300) null) insert into #tmpMsxAccountName(msx_connection, msx_credential_id, msx_credential_name, msx_login_name) exec msdb.dbo.sp_msx_get_account declare @DatabaseMailProfile nvarchar(255) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'DatabaseMailProfile', @param = @DatabaseMailProfile OUT, @no_output = N'no_output' declare @AgentMailType int exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'UseDatabaseMail', @param = @AgentMailType OUT, @no_output = N'no_output' drop table #tmp_sp_get_sqlagent_properties drop table #tmpMsxAccountName @@SERVERNAME serverproperty(N'Servername') ISNULL(tsgsp.msx_server_name,N'') tsgsp.sqlagent_type tsgsp.sqlserver_restart tsgsp.monitor_autostart tsgsp.jobhistory_max_rows tsgsp.jobhistory_max_rows_per_job tsgsp.errorlog_file tsgsp.errorlogging_level ISNULL(tsgsp.error_recipient,N'') tsgsp.job_shutdown_timeout ISNULL(tsgsp.email_profile,N'') tsgsp.email_save_in_sent_folder tsgsp.oem_errorlog tsgsp.cpu_poller_enabled tsgsp.idle_cpu_percent tsgsp.idle_cpu_duration tsgsp.login_timeout ISNULL(tsgsp.host_login_name,N'') ISNULL(tsgsp.local_host_server,N'') tsgsp.auto_start ISNULL((select top 1 ISNULL(domain + N'\', N'') + username as [UserName] from #tmpMsxAccountName),N'') tsgsp.sysadmin_only tsgsp.replace_alert_tokens_enabled ISNULL((select top 1 msx_login_name from #tmpMsxAccountName),N'') ISNULL((select top 1 msx_credential_name from #tmpMsxAccountName),N'') ISNULL(@DatabaseMailProfile,N'') ISNULL(@AgentMailType, 0) 1 c create table #SmoMemberTemp ( role_col sysname NOT NULL, mem_col sysname NOT NULL, id_col varbinary(85) ) insert into #SmoMemberTemp (role_col, mem_col, id_col) exec master.dbo.sp_helpsrvrolemember drop table #SmoMemberTemp p.principal_id = m.member_principal_id lgnmb.mem_col p.name  lnklgn.ishqoutmap = 1 lnklgn.sid=xlnklgn.sid and ISNULL(xlnklgn.ishqoutmap,0) = 0 ll.local_principal_id = sp.principal_id ISNULL(xlnklgn.name, '') ISNULL(lnklgn.name, N'') convert(bit,lnklgn.selfoutmap) ISNULL(sp.name, '') ISNULL(ll.remote_name, N'') ll.uses_self_credential ll.modify_date  sp.xtype = N'P' OR sp.xtype = N'RF' sp.type = N'P' OR sp.type = N'RF' OR sp.type='PC' spp.object_id = sp.object_id OBJECTPROPERTY(sp.id, N'ExecIsStartup') CASE sp.xtype WHEN N'RF' THEN 1 ELSE 0 END 1 ISNULL(spp.is_auto_executed,0) CASE sp.type WHEN N'RF' THEN 1 ELSE 0 END CASE WHEN sp.type = N'P' THEN 1 WHEN sp.type = N'PC' THEN 2 ELSE 1 END  v.type = 'V' v.type = 'V' 0 v.has_opaque_metadata  (tbl.type='U' or tbl.type='S') idx.id = tbl.id and idx.indid < 2 idx.object_id = tbl.object_id and idx.index_id < 2 tbl.lob_data_space_id = dstext.data_space_id declare @PageSize float select @PageSize=v.low/1024.0 from master.dbo.spt_values v where v.number=1 and v.type='E' CASE WHEN (OBJECTPROPERTY(tbl.id, N'tableisfake')=1) THEN 1 ELSE 0 END @PageSize*((SELECT sum(sidx.dpages) FROM dbo.sysindexes sidx WHERE sidx.indid < 2 and sidx.id = tbl.id) + (SELECT isnull(sum(sidx.used), 0) FROM dbo.sysindexes sidx WHERE sidx.indid = 255 and sidx.id = tbl.id)) @PageSize*(SELECT sum(isnull(sidx.used,0)-isnull(sidx.dpages,0)) FROM dbo.sysindexes sidx WHERE sidx.indid < 2 and sidx.id = tbl.id) CASE idx.indid WHEN 1 THEN 1 ELSE 0 END ISNULL((SELECT top 1 s.groupname FROM dbo.sysfilegroups s, dbo.sysindexes i WHERE i.id = tbl.id and i.indid in (0,1)AND i.groupid = s.groupid), N'') tbl.replinfo idx.rows OBJECTPROPERTY(tbl.id,N'IsAnsiNullsOn') OBJECTPROPERTY(tbl.id,N'IsQuotedIdentOn') idx.rowcnt CASE idx.index_id WHEN 1 THEN 1 ELSE 0 END ISNULL(dstext.name,N'') tbl.is_replicated ISNULL( ( select sum (spart.rows) from sys.partitions spart where spart.object_id = tbl.object_id and spart.index_id < 2), 0) tbl.uses_ansi_nulls OBJECTPROPERTY(tbl.object_id,N'IsQuotedIdentOn') 0 ISNULL((select @PageSize * SUM(CASE WHEN a.type <> 1 THEN a.used_pages WHEN p.index_id < 2 THEN a.data_pages ELSE 0 END) FROM sys.indexes as i JOIN sys.partitions as p ON p.object_id = i.object_id and p.index_id = i.index_id JOIN sys.allocation_units as a ON a.container_id = p.partition_id where i.object_id = tbl.object_id),0.0) ISNULL((select @PageSize * SUM(a.used_pages - CASE WHEN a.type <> 1 THEN a.used_pages WHEN p.index_id < 2 THEN a.data_pages ELSE 0 END) FROM sys.indexes as i JOIN sys.partitions as p ON p.object_id = i.object_id and p.index_id = i.index_id JOIN sys.allocation_units as a ON a.container_id = p.partition_id where i.object_id = tbl.object_id),0.0) \! srv.srvid != 0 srv.srvid != 0 AND srv.srvname = so.srvname srv.server_id != 0 create table #tmp_srvoptions([srvname] nvarchar(255) not null, [collationcompatible] bit not null, [dataaccess] bit not null, [dist] bit not null, [dpub] bit not null, [pub] bit not null, [rpc] bit not null, [rpcout] bit not null, [sub] bit not null) declare @srvname nvarchar(255) declare @collation_compatible bit declare @data_access bit declare @dist bit declare @pub bit declare @dpub bit declare @rpc bit declare @rpc_out bit declare @sub bit create table #tmp(opt nvarchar(100)) declare srvname_cursor cursor for select srvname FROM dbo.sysservers WHERE srvid <> 0 open srvname_cursor fetch next from srvname_cursor into @srvname while @@FETCH_STATUS = 0 begin truncate table #tmp insert #tmp exec sp_serveroption @srvname set @collation_compatible = case when exists ( select * from #tmp where opt = 'collation compatible') then 1 else 0 end set @data_access = case when exists ( select * from #tmp where opt = 'data access') then 1 else 0 end set @dist = case when exists ( select * from #tmp where opt = 'dist') then 1 else 0 end set @dpub = case when exists ( select * from #tmp where opt = 'dpub') then 1 else 0 end set @pub = case when exists ( select * from #tmp where opt = 'pub') then 1 else 0 end set @rpc = case when exists ( select * from #tmp where opt = 'rpc') then 1 else 0 end set @rpc_out = case when exists ( select * from #tmp where opt = 'rpc out') then 1 else 0 end set @sub = case when exists ( select * from #tmp where opt = 'sub') then 1 else 0 end insert into #tmp_srvoptions([srvname], [collationcompatible], [dataaccess], [dist], [dpub], [pub], [rpc], [rpcout], [sub]) values (@srvname, @collation_compatible, @data_access, @dist, @dpub, @pub, @rpc, @rpc_out, @sub) fetch next from srvname_cursor into @srvname end close srvname_cursor deallocate srvname_cursor drop table #tmp drop table #tmp_srvoptions srv.srvname srv.srvid ISNULL(srv.catalog,N'') ISNULL(srv.datasource,N'') ISNULL(srv.location,N'') srv.srvproduct srv.providername null so.collationcompatible so.dataaccess so.dist so.dpub so.pub so.rpc so.rpcout so.sub srv.collationcompatible srv.dataaccess srv.dist srv.dpub srv.pub srv.rpc srv.rpcout srv.sub ISNULL(COLLATIONPROPERTYFROMID(srv.srvcollation, 'name'),N'') srv.connecttimeout srv.lazyschemavalidation srv.querytimeout srv.useremotecollation srv.name srv.server_id ISNULL(srv.catalog,N'') ISNULL(srv.data_source,N'') ISNULL(srv.location,N'') srv.product srv.provider srv.is_collation_compatible srv.is_data_access_enabled srv.is_distributor 0 srv.is_publisher srv.is_remote_login_enabled srv.is_rpc_out_enabled srv.is_subscriber ISNULL(srv.collation_name,N'') srv.connect_timeout srv.lazy_schema_validation srv.query_timeout srv.uses_remote_collation srv.modify_date null  s.name s.langid s.dateformat s.alias s.days s.datefirst s.months s.shortmonths s.upgrade s.lcid s.msglangid  create table #filetmpfin (Name nvarchar(255) NOT NULL, IsFile bit NULL) if(@Name is null) begin create table #filetmp (Name nvarchar(255) NOT NULL, depth int NOT NULL, IsFile bit NULL ) insert #filetmp EXECUTE master.dbo.xp_dirtree @Path, 1, 1 insert #filetmpfin select Name, IsFile from #filetmp f drop table #filetmp end if(NOT @Name is null) begin declare @FullName nvarchar(300) if(@Path is null) select @FullName = @Name else select @FullName = @Path + '\' + @Name create table #filetmp2 ( Exist bit NOT NULL, IsDir bit NOT NULL, DirExist bit NULL ) insert #filetmp2 EXECUTE master.dbo.xp_fileexist @FullName insert #filetmpfin select @Name, 1-IsDir from #filetmp2 where Exist = 1 or IsDir = 1 drop table #filetmp2 end drop table #filetmpfin Name @Path+'\'+Name @Path IsFile  create table #fixdrv ( Name sysname NOT NULL, Size int NOT NULL, Type sysname NULL ) insert #fixdrv (Name, Size) EXECUTE master.dbo.xp_fixeddrives update #fixdrv set Type = 'Fixed' where Type IS NULL insert #fixdrv (Name, Size) EXECUTE master.dbo.xp_fixeddrives 1 update #fixdrv set Type = 'Remote' where Type IS NULL insert #fixdrv (Name, Size) EXECUTE master.dbo.xp_fixeddrives 2 update #fixdrv set Type = 'Removable' where Type IS NULL insert #fixdrv (Name, Size) EXECUTE master.dbo.xp_fixeddrives 3 update #fixdrv set Type = 'CD-ROM' where Type IS NULL update #fixdrv set Name = Name + ':' drop table #fixdrv Name Size Type \ create table #cdromdrv ( Name sysname NOT NULL, Size int NOT NULL ) insert #cdromdrv EXECUTE master.dbo.xp_fixeddrives 3 update #cdromdrv set Name = Name + ':' drop table #cdromdrv Name Size 2 create table #fixdrv ( Name sysname NOT NULL, Size int NOT NULL ) insert #fixdrv EXECUTE master.dbo.xp_fixeddrives 2 update #fixdrv set Name = Name + ':' drop table #fixdrv Name Size 0 create table #fixdrv ( Name sysname NOT NULL, Size int NOT NULL ) insert #fixdrv EXECUTE master.dbo.xp_fixeddrives 1 update #fixdrv set Name = Name + ':' drop table #fixdrv Name Size - create table #fixdrv ( Name sysname NOT NULL, Size int NOT NULL ) insert #fixdrv EXECUTE master.dbo.xp_fixeddrives update #fixdrv set Name = Name + ':' drop table #fixdrv Name Size i rl.isapprole = 1 rl.type = 'A' rl.name rl.uid rl.createdate rl.updatedate rl.principal_id rl.default_schema_name rl.create_date rl.modify_date 4 rl.issqlrole = 1 ou.uid = rl.altuid rl.type = 'R' ou.principal_id = rl.owning_principal_id rl.name rl.uid rl.createdate rl.updatedate rl.principal_id rl.create_date rl.modify_date ou.name  ((u.issqlrole != 1 and u.isapprole != 1 ) or (u.sid=0x00)) and u.isaliased != 1 and u.hasdbaccess != 0 u.type in ('U', 'S', 'G', 'C', 'K') dp.grantee_principal_id = u.principal_id and dp.type = N'CO' cert.sid = u.sid ak.sid = u.sid u.name u.uid ISNULL(suser_sname(u.sid),N'') CASE WHEN u.uid = 1 OR u.uid = 16382 OR u.uid = 16383 THEN 1 ELSE 0 END CASE WHEN 0 <> u.isntuser THEN 0 WHEN 0 <> u.isntgroup THEN 1 ELSE 2 END 0 u.sid u.hasdbaccess u.createdate u.updatedate u.principal_id ISNULL(suser_sname(u.sid),N'') CASE WHEN u.principal_id < 5 OR u.principal_id = 16382 OR u.principal_id = 16383 THEN 1 ELSE 0 END CASE WHEN N'U' = u.type THEN 0 WHEN N'G' = u.type THEN 1 WHEN N'S' = u.type THEN 2 WHEN N'C' = u.type THEN 3 WHEN N'K' = u.type THEN 4 END CASE dp.state WHEN N'G' THEN 1 WHEN 'W' THEN 1 ELSE 0 END u.sid CASE WHEN N'C' = u.type THEN 1 WHEN N'K' = u.type THEN 2 WHEN N'S' = u.type AND suser_sname(u.sid) IS NULL THEN 3 ELSE 0 END ISNULL(cert.name,N'') ISNULL(ak.name,N'') u.create_date u.modify_date ISNULL(u.default_schema_name,N'') W create table #loginmappings( LoginName sysname NULL, DBName sysname NULL, UserName sysname NULL, AliasName sysname NULL ) declare @db_name nvarchar(512) declare crs cursor local fast_forward for ( select name from master.dbo.sysdatabases where 1 = has_dbaccess(name)) for ( select name from sys.databases where 1 = has_dbaccess(name)) open crs fetch crs into @db_name while @@fetch_status >= 0 begin set @db_name = quotename(@db_name) exec('use ' + @db_name + ' INSERT #loginmappings select suser_sname(u.sid), db_name(), u.name, null from dbo.sysusers u where suser_sname(u.sid) is not null') exec('use ' + @db_name + ' INSERT #loginmappings select suser_sname(u.sid), db_name(), u.name, null from sys.database_principals AS u where suser_sname(u.sid) is not null') fetch crs into @db_name end close crs deallocate crs drop table #loginmappings logmap.LoginName logmap.DBName logmap.UserName  log.language = l.name log.type in ('U', 'G', 'S', 'C', 'K') AND log.principal_id not between 101 and 255 AND log.name <> N'##MS_AgentSigningCertificate##' l.name = log.default_language_name sqllog.principal_id = log.principal_id sp.grantee_principal_id = log.principal_id and sp.type = N'COSQ' c.credential_id = log.credential_id cert.sid = log.sid ak.sid = log.sid log.loginname ISNULL(log.language, N'') l.alias log.dbname log.denylogin CASE WHEN 0 <> log.isntuser THEN 0 WHEN 0 <> log.isntgroup THEN 1 ELSE 2 END CASE WHEN (0 = log.isntuser AND 0 = log.isntgroup) THEN 99 WHEN (0 = log.denylogin and 0 = log.hasaccess) THEN 0 WHEN (0 = log.denylogin ) THEN 1 ELSE 2 END log.hasaccess log.sid log.createdate log.updatedate CASE log.sid WHEN 0x01 THEN 1 ELSE 0 END log.name ISNULL(log.default_language_name,N'') l.alias log.default_database_name CASE sp.state WHEN N'D' THEN 1 ELSE 0 END CASE WHEN N'U' = log.type THEN 0 WHEN N'G' = log.type THEN 1 WHEN N'S' = log.type THEN 2 WHEN N'C' = log.type THEN 3 WHEN N'K' = log.type THEN 4 END CASE WHEN (N'U' != log.type AND N'G' != log.type) THEN 99 WHEN (sp.state is null) THEN 0 WHEN (N'G'=sp.state) THEN 1 ELSE 2 END CASE WHEN (sp.state is null) THEN 0 ELSE 1 END log.sid sqllog.is_policy_checked sqllog.is_expiration_checked log.create_date log.modify_date LOGINPROPERTY(log.name, N'IsLocked') LOGINPROPERTY(log.name, N'IsExpired') LOGINPROPERTY(log.name, N'IsMustChange') log.principal_id ISNULL(c.name,N'') ISNULL(cert.name,N'') ISNULL(ak.name,N'') log.is_disabled CASE WHEN log.principal_id < 256 THEN 1 ELSE 0 END ' v1.low=0 and v1.type='SRV' r.type ='R' and r.name != N'public' v1.name = r.name and v1.low = 0 v1.name v2.name r.name r.principal_id N'' j s.groupid = 0 s.type = 1 and s.database_id = db_id() tspclog.DatabaseName = db_name() create table #tmplogspc (DatabaseName sysname, LogSize float, SpaceUsedPerc float, Status bit) insert #tmplogspc EXEC ('dbcc sqlperf(logspace)') drop table #tmplogspc tspclog.LogSize * tspclog.SpaceUsedPerc * 10.24 u s.type = 0 and s.database_id = db_id() and (s.drop_lsn IS NULL) create table #tmpspc (Fileid int, FileGroup int, TotalExtents int, UsedExtents int, Name sysname, FileName nchar(520)) insert #tmpspc EXEC ('dbcc showfilestats') drop table #tmpspc FILEPROPERTY(s.name, N'IsPrimaryFile') tspc.UsedExtents*convert(float,64) (tspc.TotalExtents - tspc.UsedExtents)*convert(float,64)  declare @PageSize float select @PageSize=v.low/1024.0 from master..spt_values v where v.number=1 and v.type='E' g.groupname g.groupid g.status & 0x08 g.status & 0x10 ISNULL((select sum(s.size * @PageSize) from dbo.sysfiles s where s.groupid = g.groupid), 0) cast(g.name as varbinary(256)) g.data_space_id g.is_read_only g.is_default ISNULL((select sum(gs.size)*convert(float,8) from sys.database_files gs where gs.data_space_id = g.data_space_id), 0) = t.dbname = dtb.name create table #tmplog (dbname sysname null, log_size float null, log_space_used float null, status int) INSERT INTO #tmplog EXEC ('DBCC SQLPERF(LOGSPACE)') drop table #tmplog df.database_id = dtb.database_id and 1=df.data_space_id and 1 = df.file_id dmi.database_id = dtb.database_id drs.database_id = dtb.database_id dtb.name dtb.dbid suser_sname(dtb.sid) dtb.crdate rtrim(dtb.filename) NULL t.log_size*(100-t.log_space_used)*10.24 NULL NULL 0 (select count(*) from master.dbo.sysprocesses p where dtb.dbid=p.dbid) dtb.cmptlevel '' dtb.category (select top 1 fg.groupname from dbo.sysfilegroups as fg where fg.status & 0x10 <> 0 ) case when dtb.name in ('master','model','msdb','tempdb') then 1 else category & 16 end dtb.name dtb.database_id suser_sname(dtb.owner_sid) dtb.create_date null 0 0 0 0 0 (select count(*) from master.dbo.sysprocesses p where dtb.database_id=p.dbid) dtb.compatibility_level '' dtb.is_published*1+dtb.is_subscribed*2+dtb.is_merge_published*4 dtb.service_broker_guid dtb.is_fulltext_enabled dtb.collation_name ISNULL((select top 1 ftc.name from sys.fulltext_catalogs as ftc where ftc.is_default=1),N'') (select top 1 ds.name from sys.data_spaces as ds where ds.is_default=1) 0 isnull(dtb.source_database_id, 0) (select count(1) from sys.databases dtbmir where dtbmir.source_database_id = dtb.database_id) ISNULL(DB_NAME(dtb.source_database_id), N'') dmi.mirroring_partner_name dmi.mirroring_role coalesce(dmi.mirroring_safety_level + 1, 0) coalesce(dmi.mirroring_state + 1, 0) dmi.mirroring_witness_name coalesce(dmi.mirroring_witness_state + 1, 0) case when dmi.mirroring_partner_name is null then 0 else 1 end dmi.mirroring_guid dmi.mirroring_role_sequence dmi.mirroring_safety_sequence dmi.mirroring_failover_lsn dtb.log_reuse_wait case when DATABASEPROPERTY(dtb.name,'IsShutDown') is null then 0x200 else 0 end | case when 1 = dtb.is_in_standby then 0x40 else 0 end | case when 1 = dtb.is_cleanly_shutdown then 0x80 else 0 end | case dtb.state when 1 then 0x2 when 2 then 0x8 when 3 then 0x4 when 4 then 0x10 when 5 then 0x100 when 6 then 0x20 else 1 end drs.recovery_fork_guid drs.database_guid dtb.is_auto_create_stats_on dtb.is_auto_update_stats_on case when dtb.name in ('master','model','msdb','tempdb') then 1 else dtb.is_distributor end DATABASEPROPERTYEX(dtb.name, 'IsFulltextEnabled') DATABASEPROPERTYEX(dtb.name, 'Collation') case -- if all these are false then we are in the Normal state -- except some return NULL if it's AutoClosed when (DATABASEPROPERTY(dtb.name,'IsInLoad') = 0 and (DATABASEPROPERTY(dtb.name,'IsInRecovery') = 0 or DATABASEPROPERTY(dtb.name,'IsInRecovery') is null) and (DATABASEPROPERTY(dtb.name,'IsNotRecovered') = 0 or DATABASEPROPERTY(dtb.name,'IsNotRecovered') is null) and DATABASEPROPERTY(dtb.name,'IsSuspect') = 0 and DATABASEPROPERTY(dtb.name,'IsOffline') = 0 and DATABASEPROPERTY(dtb.name,'IsInStandBy') = 0 and (DATABASEPROPERTY(dtb.name,'IsShutDown') = 0 or DATABASEPROPERTY(dtb.name,'IsShutDown') is null) and DATABASEPROPERTY(dtb.name,'IsEmergencyMode') = 0) then 1 else 0 end | case when DATABASEPROPERTY(dtb.name,'IsInLoad') = 1 then 2 else 0 end | case when DATABASEPROPERTY(dtb.name,'IsInRecovery') = 1 and DATABASEPROPERTY(dtb.name,'IsNotRecovered') = 1 then 4 else 0 end | case when DATABASEPROPERTY(dtb.name,'IsInRecovery') = 1 then 8 else 0 end | case when DATABASEPROPERTY(dtb.name,'IsSuspect') = 1 then 16 else 0 end | case when DATABASEPROPERTY(dtb.name,'IsOffline') = 1 then 32 else 0 end | case when DATABASEPROPERTY(dtb.name,'IsInStandBy') = 1 then 64 else 0 end | case when DATABASEPROPERTY(dtb.name,'IsShutDown') = 1 then 128 when DATABASEPROPERTY(dtb.name,'IsShutDown') is null then (512 + 128) else 0 end | case when DATABASEPROPERTY(dtb.name,'IsEmergencyMode') = 1 then 256 else 0 end ( case LOWER(convert( nvarchar(128), DATABASEPROPERTYEX(dtb.name, 'Updateability'))) when 'read_write' then 1 else 0 end) DATABASEPROPERTYEX(dtb.name, 'Version') CHARINDEX(N'_CS_', CAST(DATABASEPROPERTYEX(dtb.name, 'Collation') AS nvarchar(255))) DATABASEPROPERTY(dtb.name,'IsFulltextEnabled') 0 0 0 0 0 0 0 0 0 '' has_dbaccess(dtb.name) (select max(backup_finish_date) from msdb..backupset where type = 'L' and database_name = dtb.name) (select max(backup_finish_date) from msdb..backupset where type = 'D' and database_name = dtb.name) i lSystem.Resources.ResourceReader, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSetPADPADPÉdl dǬ 4H !L~G긄ѿr\ŕ\⯯E݆}X/l hkj:3ra7jc0VPh+qm6x{78eBSERv\+@CouldNotGetInfoFromDependencyRow,CouldNotInstantiateObj(6DatabaseNameMustBeSpecifiedFFDatabaseNameMustBeSpecifiedinTheUrnf*EnumObjectTagNotFound"FailedToCreateUrn(FailedToLoadAssembly&FailedToLoadResFile$IncorectVersionTag0InvalidConfigurationFile*InvalidConnectionType InvalidSqlServer(InvalidUrnForDependsInvalidVersion!MissingSectionC,NoClassNamePostProcessmNotDbObjectNotDerivedFromNotSingleDb6NullVersionOnLoadingCfgFile$OnlyPathOrFullName!&PropMustBeSpecifiedD8QueryNotSupportedPostProcessdSqlServer80NameSqlServer90NameTooManyDbLevels0TooManyLinkMultipleElemsUnknownOperatorUnknownType,6UnsupportedTypeDepDiscoveryB&无法检索依赖关系信息({0})。无法实例化对象 {0}。必须指定数据库名称。1必须在以下 urn 中指定数据库名称: {0}找不到枚举对象标记。$无法为对象代码 {0} 创建 Urn无法加载程序集 {0}。找不到文件 {0}。 源中可能缺少该文件或该文件在 config.xml 中存在拼写错误，或者未保留区分大小写方面的特性。版本标记不正确。配置文件无效。连接类型无效。{0} 上不支持此操作。$Urn 对于依赖项发现 {0} 无效 版本 {0} 不支持此操作。(配置文件无效: 缺少 {0} 部分。) 标记缺少 class_name。对象不在数据库中。{0} 不是从 {1} 派生的。!对象不在单个数据库中。'加载配置文件时未指定版本。!只需指定 Path 或 FullName。必须在 {1} 上指定 {0}。7由于以下这些属性而无法提供 DataReader: {0}SQL Server 2000SQL Server 2005数据库级别过多。=在 LinkMultiple 中只支持不超过 4 个元素数目: {0}未知运算符。未知类型: {0}。K在依赖项发现中不支持 {0}。只支持以下类型的对象: {1}。 qn8Uw᷅3,.>NAw9ޡ ;#)L 3?eqml^i۵/ccOo$Z= |eU\_`+nq4L`p!#8ayIa`KBSJB v2.0.50727l0 #~ X#Strings##US##GUID $#Blob3-  07oI ] ~ #*177T<mAGKuRYW[_b*'gMmhBq@w|uռ#?`R21Pgw! 9yU )-4/Ob3aH5r:CUE{OP>X_c @fk-m>uZ}z+HhT"A!={\q7QA,YdF%=^x%[-2<PBE H( MB QV Um X M[ %_  V  ̎  è r& 6 )E CW Sh     y W    |  7 )Q $c &p A( 8 hL V hg j a} y &< U ̕i }}   <  t   q, C Z Pz & \0 8 < > 1CN,T<WYs]m_cMgjppt=w)z8~IuVcsTr#Is 'D"`9v?Tkns/y1{}  .=JYbn,Gv$| 7Sgqy( .&36@S'W ` b\f*i34m?pK|_9vّ[OdQLr%24HI=]Zimd{GH .52B0Q&e/vAH^%ei ou`microsoft.sqlserver.sqlenum.resourceszh-CHSMail_ErrorLog.xmlDatabaseDiagram.xmlNS.NotificationComputedField.xmlNS.NotificationField.xmlNS.EventField.xmlNS.SubscriptionChronicle.xmlNS.SubscriptionConditionScheduledRule.xmlNS.SubscriptionScheduledRule.xmlNS.SubscriptionConditionEventRule.xmlNS.SubscriptionEventRule.xmlNS.SubscriptionField.xmlNS.SubscriptionClass.xmlNS.ProtocolField.xmlNS.ProtocolRetrySchedule.xmlNS.NotificationClassProtocol.xmlNS.ContentFormatterArgument.xmlNS.ContentFormatter.xmlNS.NotificationClass.xmlNS.HostedEventProviderArgument.xmlNS.HostedEventProvider.xmlNS.NonHostedEventProvider.xmlNS.EventChronicleRule.xmlNS.EventChronicle.xmlNS.EventClass.xmlNS.Distributor.xmlNS.VacuumSchedule.xmlNS.Application.xmlNS.InstanceDatabaseLogFile.xmlNS.InstanceDatabaseFile.xmlNS.InstanceDatabaseFileGroup.xmlNS.InstanceDatabaseOptions.xmlNS.ApplicationDatabaseLogFile.xmlNS.ApplicationDatabaseFile.xmlNS.ApplicationDatabaseFileGroup.xmlNS.ApplicationDatabaseOptions.xmlNS.Generator.xmlNS.ProtocolDefinition.xmlNS.DeliveryChannelArgument.xmlNS.DeliveryChannel.xmlNS.Instance.xmlNS.NotificationServices.xmlMasterKeyEncryption.xmlDatabaseMasterKey.xmlServiceMasterKey.xmlServerProxyAccount.xmlagent_operator_categories.xmltransaction.xmlagent_job_categories.xmlagent_alert_categories.xmlKeyEncryption.xmlFullTextFile.xmlNumberedSPParams.xmlNumberedStoredProcedure.xmludfcolumn.xmlparameter.xmltemp_table.xmlasymmetrickey.xmlsymmetrickey.xmlsoap_endpoint_method.xmltcp_endpoint.xmlhttp_endpoint.xmlvia_endpoint.xmlservice_broker_endpoint.xmldatabase_mirroring_endpoint.xmlinc_urn_single.xmlsoap_endpoint.xmlendpoint.xmlMailServer.xmlMailProfilePrincipals.xmlMailProfileAccounts.xmlServerDdlTriggerEvent.xmlinc_ddl_trigger_event.xmlDatabaseDdlTriggerEvent.xmlinc_server_sql_module_link.xmlServerDdlTrigger.xmlDatabaseDdlTrigger.xmlinc_named_object.xmlMail.xmlConfigurationValue.xmlMailAccount.xmlMailProfile.xmlCredential.xmlinc_urn_collate_default.xmlXmlType.xmlXmlNamespace.xmlXmlSchemaCollection.xmlDatabaseMirroringWitnessRole.xmlfulltext_ErrorLogText.xmlfulltext_ErrorLog.xmlOLEDBProviderSetting.xmlcertificate.xmlProxyAccountPrincipals.xmlAgentSubsystems.xmlProxyAccount.xmlLogMarkHistory.xmlMaintenancePlanDeprecated.xmlMaintSubPlanLogDetail.xmlMaintSubPlanLog.xmlMaintenanceSubPlan.xmlMaintenancePlan.xmlinc_urn_soapmethod.xmlSPParams.xmlDatabaseOptions.xmlinc_urn_message.xmlIndexFragDetail.xmlIndexFragSampled.xmlIndexFragFast.xmlinc_IndexFrag.xmlsynonym.xmlusermessage.xmlsysmessage.xmlSrvObjectPerm.xmlDBObjectPerm.xmlYukonSchemaObjectPerm.xmlYukonObjectPerm.xmlTablePerm.xmlSrvYukonPerm.xmlSrvYukonObjectPerm.xmlShilohYukonPerm.xmlinc_perm.xmlDBPerm.xmldbfixedroleperm.xmlColumnPerm.xmlDatabaseActiveDirectory.xmlServerActiveDirectory.xmlAgentPerfInfo.xmlPerfInfo.xmlFullTextLanguage.xmlYukonuserownedobjectSchema.xmlYukonuserownedobject.xmlFullTextIndexColumn.xmlFullTextIndex.xmlSchema.xmlFullTextCatalog.xmlFullTextService.xmlUserDefinedAggregateParameter.xmlUserDefinedAggregate.xmlUserDefinedType.xmlSqlAssemblyFile.xmlSqlAssembly.xmlOperatorJobNotification.xmlOperatorNotification.xmlAlertNotification.xmlrestore_plan.xmlmixed_module_link.xmlsql_module_link.xmlinc_column_reference.xmlinc_type_reference.xmlDbExtendedProperty.xmlinc_level2SupportProperties.xmlLevel2IndexExtendedProperty.xmlLevel2ExtendedProperty.xmlLevel1ExtendedProperty.xmlLevel0ExtendedProperty.xmlinc_shilohExtendedProperty.xmlExtendedProperty.xmlinc_type.xmlinc_storage.xmlPartitionSchemeFileGroup.xmlPartitionScheme.xmlPartitionFunctionRangeValue.xmlPartitionFunctionParameter.xmlPartitionFunction.xmlPartitionSchemeParameter.xmlinc_constraint.xmlinc_system_table_view_sp_udf.xmlinc_system_object.xmlinc_object.xmlComputedText.xmlFKColumn.xmlSettings.xmlInformation.xmlUserOption.xmlStatisticColumn.xmlAvailableMedia.xmlagent_ErrorLogText.xmlagent_ErrorLog.xmlagent_jobtargetservers.xmlagent_jobhistory.xmlagent_jobalert.xmlinc_fulltext.xmlagent_targetservermember.xmlagent_targetservergroup.xmlagent_alertsystem.xmlagent_targetserver.xmlagent_operator.xmlagent_alert.xmlbackupmediaset.xmlbackupmediafamily.xmlbackupfile.xmlrestorefilegroup.xmlrestorefile.xmlrestorehistory.xmlbackupset.xmlinc_DbFile.xmlinc_text.xmlTapeDevice.xmlLock.xmlProcess.xmlErrorLogText.xmlErrorLog.xmlDatabaseLocks.xmlCollation.xmlStatistic.xmlText.xmlDefaultConstrain.xmlinc_objprop_table_view.xmlinc_ruledef80.xmlinc_urn.xmlinc_urn_schema.xmlinc_sql_module.xmlinc_sql_module_JustText.xmlDefaultDataType.xmlDefaultColumn.xmlXStoredProcedure.xmlBackupDevice.xmlsdt.xmlConnection.xmlBoundColumn.xmlUDFParams.xmlForeignKey.xmlUddt.xmlDefault.xmlConfiguration.xmlRuleDataType.xmlRuleColumn.xmlRule.xmlNTLogin.xmlNTGroup.xmlUserOwnedObject.xmlDatabaseRoleMember.xmlAditionalParameters.xmlJob.xmlColumn.xmlUDF.xmlTrigger.xmlCheck.xmlServer.xmlPrimaryChildren.xmlOLEDBProvProp.xmlOLEDBProvider.xmlPrimaryFile.xmlSharedSchedule.xmlSchedule.xmlagent_jobschedule.xmlJobStepOutputLog.xmlJobStep.xmlIndexedColumn.xmlIndex.xmlJobServer.xmlMember.xmlLinkedServerLogin.xmlStoredProcedure.xmlView.xmltable.xmlLinkedServer.xmlLanguage.xmlDiskFile.xmlDrive.xmlCdromDrive.xmlRemovableDrive.xmlRemoteDrive.xmlFixedDrive.xmlApplicationRole.xmlDatabaseRole.xmlUser.xmlDatabaseMappings.xmlLogin.xmlServerRole.xmlLogFile.xmlFile.xmlFileGroup.xmlDatabase.xmlMicrosoft.SqlServer.Management.Smo.SqlEnum.StringSqlEnumerator.zh-CHS.resourcesmicrosoft.sqlserver.sqlenum.resources.dll գZ#pD{&)$$RSA1''6n_1:fl/y2}/R4H<=\]Ǽ(k,Q\$+Au2IRmRo{l؂O1 ˢ#V{-Pb왹J|};(x   _CorDllMainmscoree.dll% @0 HX 004VS_VERSION_INFO w wDVarFileInfo$TranslationStringFileInfol080404b0LCompanyNameMicrosoft Corporation,FileDescription : FileVersion9.00.1399.00t*InternalNamemicrosoft.sqlserver.sqlenum.resources.dllXLegalCopyright Microsoft Corp. OYu@b gCg)R0QLegalTrademarksMicrosoft /f Microsoft Corporation vlQFUh0Windows(TM) /f Microsoft Corporation vFUh|*OriginalFilenamemicrosoft.sqlserver.sqlenum.resources.dllJProductNameMicrosoft SQL Server> ProductVersion9.00.1399.00 40 *H 01 0 +0h +7Z0X03 +70% <<<Obsolete>>>0!0 +:O7+LO6`à00-GߍRFCmH 10  *H 01 0 UZA10U Western Cape10U Durbanville10 U Thawte10U Thawte Certification10UThawte Timestamping CA0 031204000000Z 131203235959Z0S1 0 UUS10U VeriSign, Inc.1+0)U"VeriSign Time Stamping Services CA0"0  *H 0 ʲ }uNgadڻ30X~k6xw~o< hlʽR-H=]_/kLR`@~ ?Ǵ߇_zj1.G 1s W-x43h/Š*Ë!fXWou<&]'x1"ijGC_^|}bM "Vͮv M٠h;004+(0&0$+0http://ocsp.verisign.com0U00AU:0806420http://crl.verisign.com/ThawteTimestampingCA.crl0U% 0 +0U0$U0010U TSA2048-1-530  *H JkXD1y+LͰXn)^ʓR G'/8ɓN"b?7!Op18UN$ҩ'NzaA*^ݻ+>W~ +;R8'?J00 +)2 ^v0  *H 0S1 0 UUS10U VeriSign, Inc.1+0)U"VeriSign Time Stamping Services CA0 031204000000Z 081203235959Z0W1 0 UUS10U VeriSign, Inc.1/0-U&VeriSign Time Stamping Services Signer0"0  *H 0 P(HhzDfu]~ĸc&=C|8%Usu'iN \ *UV!a3kݣ7e S\|f5_EvNS \0"7LB U?R,z򢪍5]j=k㿖`@DQn*(P{J 0kX@( ~|vqiOG05!b<+َ*{\{❥o<00<<>c@0  *H 0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 970110070000Z 201231070000Z0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0"0  *H 0 p;N(x^0ꢩ%_L >|Q`2kBdyvT뜆fkzb#<Ŀ-fh&:, X&F >8,(9IBlUa|`-wL陴d;P1$+=c`Xe7RӿUE:TNzmtN̖ (!W`i7Kc@0  *H  5$w\`2 >:!W,Gb;;Z6Ti$m?̪|1=pjOiCZ Ob{+7%-e%cT!RnC2gl QRǽ0 1 )M[WeIRT(~ū7,zwvj?6A5jj5EZ38nM b T?FUp:uҠ00j O "}ly~0  *H 0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority0 020523080000Z 110925080000Z01 0 UUS10U Washington10URedmond10U Microsoft Corporation1+0)U "Copyright (c) 2000 Microsoft Corp.1#0!UMicrosoft Code Signing PCA0 0  *H  0 >Pz$%v!*VNʜ5y-ĨcɷֱRƽŨkSPdԂh@xD8NcQ=7c#;q@4GkF's"BQRӣ?qm!D_Bəd 4D{/ߛ!X1AU8~XYy%*/?8x>Bh~"hJxDRGOg{ }q<+f-+4He<&Ro*0&0U% 0 +0U0[pir#Q~Mˡr0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authority<<>c@0 +70U%+K]rT*S0 +7  SubCA0 UF0U00  *H dJti'ZS'сsκꓗ܏:.tt;@Q_<2OY(rq/5B/b11BO8pA8` < +VKJ"oD+pN,:q2X5Rۑ@o)Bp}loۜ^,_³{;St*g'u@ Fr6mkfS5jrE]f,a Yf ;|00ɠ aXZ0  *H 01 0 UUS10U Washington10URedmond10U Microsoft Corporation1+0)U "Copyright (c) 2000 Microsoft Corp.1#0!UMicrosoft Code Signing PCA0 050105232019Z 060405233019Z0t1 0 UUS10U Washington10URedmond10U Microsoft Corporation10UMicrosoft Corporation0"0  *H 0 8'^̪:;b1FFӳŸLg(C;uyj3azy]hpw/u/JA||ˇCt@WXՒ$qIU|e8#>)lƞp[}7gw ΅N45S2W(l@ I67I*k̎ֆFzJESx/.5kL$iin>LAb]~\L'1kVLq=*qM@0<0U0U4wh424c10U% 0 +0U#0%+K]rT*Str0p1+0)U "Copyright (c) 1997 Microsoft Corp.10U Microsoft Corporation1!0UMicrosoft Root Authorityj O "}ly~0JUC0A0?=;9http://crl.microsoft.com/pki/crl/products/CodeSignPCA.crl0  *H   &t<J'GrQKBQ#;e-LP8W^:sO3-%;YЮ R dwwu6 l3`/m)۵k"@+2Pƶ6w)T>~qYʄ/D"!H cro,+:YJ!埩bPuv_ؠ~W҉}C10001 0 UUS10U Washington10URedmond10U Microsoft Corporation1+0)U "Copyright (c) 2000 Microsoft Corp.1#0!UMicrosoft Code Signing PCA aXZ0 +0 *H  1  +70 +7 10  +70# *H  1P-^;):7{`0X +7 1J0H*(Microsoft SQL Serverhttp://www.microsoft.com0  *H <3Αy@ M˭`H ,eUe8Ċ2nc'E VԠ D]| 1DNչV+p/:BggيJ*7U rR2C^Hd$V} C0b50Ơ"36FpS!<$E0]8eO8bFbrҴU*>b 5{e ;up/2RDu;KOvs\ 1]F$͢A  Rm!XN