--Job start date: Feb 15 2012 10:21AM
USE EnterpriseVaultDirectory
DBCC CHECKDB WITH DATA_PURITY
-- Database original recovery model - FULL
-- Waiting to change recovery model to SIMPLE...
ALTER DATABASE EnterpriseVaultDirectory SET RECOVERY SIMPLE
IF @@error <> 0
		BEGIN
			PRINT 'Failed to set recovery model to SIMPLE. Script stopped. Please try again.'
			RETURN
		END
USE tempdb
-- create tempdb tables
-- LOCK DATABASE
-- ***
USE EnterpriseVaultDirectory
ALTER DATABASE EnterpriseVaultDirectory SET single_user WITH ROLLBACK IMMEDIATE
IF @@error <> 0 
		BEGIN
			PRINT 'Could not alter database to sinle_use mode'
			RAISERROR('Could not alter database to sinle_use mode', 16, 1)
			RETURN
		END
--Collect info section start time: Feb 15 2012 10:21AM
-- GET UDF INFO (both schema-bound and uses_database_collation)
-- GET VIEW INFO (both schema-bound and uses_database_collation)
-- GET PK INFO
-- GET FOREIGN KEY CONSTRAINTS INFO
-- GET FOREIGN KEY CONSTRAINTS & COLUMNS INFO
-- GET DEFAULT CONSTRAINTS INFO
-- GET CHECK CONSTRAINTS INFO
-- GET COMPUTED COLUMNS INFO
-- GET TRIGGER INFO
-- GET TRIGGER ORDER INFO
-- GET INDEXES INFO
-- GET PERMISSIONS INFO
-- GET USER STATISTICS INFO
-- GET USER STATISTICS INFO WITH COLUMNS
--
--Collect info section finish time: Feb 15 2012 10:21AM
--
--
--DROP info section start time: Feb 15 2012 10:21AM
--
-- ***
-- DROP UDF
-- DROP UDF passed.
-- ***
-- DROP VIEWS
-- DROP VIEW passed.
-- ***
-- DROP TRIGGERS
-- DROP TRIGGERS PASSED.
-- ***
-- DROP HAND-MADE STATISTICS
-- DROP HAND-MADE STATISTICS passed
-- ***
-- DROP FK
ALTER TABLE [dbo].[ArchiveFolder] DROP CONSTRAINT [FK_ArchiveFolder_ArchiveFolder]
ALTER TABLE [dbo].[ArchiveFolder] DROP CONSTRAINT [FK_ArchiveFolder_Root]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [FK_ArchivingRetrievalTask_ExchangeServerEntry]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [FK_ArchivingRetrievalTask_Task]
ALTER TABLE [dbo].[ComputerEntry] DROP CONSTRAINT [FK_ComputerEntry_DefVaultStoreEntry]
ALTER TABLE [dbo].[ComputerEntry] DROP CONSTRAINT [FK_ComputerEntry_DefIndexingServiceEntry]
ALTER TABLE [dbo].[ComputerEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_COMPUTERENTRY]
ALTER TABLE [dbo].[FileBlockingRuleFolderFilter] DROP CONSTRAINT [FK_FileBlockingRuleFolderFilter_FileBlockingRule]
ALTER TABLE [dbo].[DnaPolicySettingsEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_DNAPOLICYSETTINGSENTRY]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [FK_ExchangeMailboxEntry_SubTask]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [FK_ExchangeMailboxEntry_PolicyEntry]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [FK_ExchangeMailboxEntry_PolicYEntry2]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [FK_ExchangeMailboxEntry_PolicyTargetGroup]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [FK_ExchangeMailboxEntry_PolicyTargetMember]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [FK_ExchangeMailboxEntry_ExchangeMailboxStore]
ALTER TABLE [dbo].[FileGroup] DROP CONSTRAINT [FK_FileGroup_SiteEntryId]
ALTER TABLE [dbo].[FileBlockingRuleSettings] DROP CONSTRAINT [FK_FileBlockingRuleSettings_FileBlockingRule]
ALTER TABLE [dbo].[FileBlockingRuleSettings] DROP CONSTRAINT [FK_FileBlockingRuleSettings_PolicyEntry]
ALTER TABLE [dbo].[ExchangePolicySettings] DROP CONSTRAINT [FK_ExchangePolicySettings_FilterEntry]
ALTER TABLE [dbo].[ExchangePolicySettings] DROP CONSTRAINT [FK_ExchangePolicySettings_PolicyEntry]
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [FK_ExchangeServerEntry_DefVaultStoreEntry]
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [FK_ExchangeServerEntry_DefIndexingServiceEntry]
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_EXCHANGESERVERENTRY]
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [FK_ExchangeServerEntry_Organization]
ALTER TABLE [dbo].[FileBlockingRule_FileGroup] DROP CONSTRAINT [FK_FileBlockingRule_FileGroup_FileBlockingRule]
ALTER TABLE [dbo].[FileBlockingRule_FileGroup] DROP CONSTRAINT [FK_FileBlockingRule_FileGroup_FileGroup]
ALTER TABLE [dbo].[ExtendedSetting] DROP CONSTRAINT [FK_ExtendedSetting_SettingType]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_FILESERVERENTRY]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_FILESERVERENTRY]
ALTER TABLE [dbo].[FileServerFolderEntry] DROP CONSTRAINT [CONS_FK_FILESERVERVOLUMEENTRY_FILESERVERFOLDERENTRY]
ALTER TABLE [dbo].[FileServerFolderEntry] DROP CONSTRAINT [CONS_FK_FOLDERPOLICYENTRY_FILESERVERFOLDERENTRY]
ALTER TABLE [dbo].[FileGroupFile] DROP CONSTRAINT [FK_FileGroupFile_FileGroupEntryId]
ALTER TABLE [dbo].[FileGroupFile] DROP CONSTRAINT [FKFileGroupFile_FileTypeIdentity]
ALTER TABLE [dbo].[FileServerVolumeArchiveEntry] DROP CONSTRAINT [CONS_FK_FILESERVERVOLUMEENTRY_FILESERVERVOLUMEARCHIVEENTRY]
ALTER TABLE [dbo].[FileServerVolumeArchiveEntry] DROP CONSTRAINT [CONS_FK_ROOT_FILESERVERVOLUMEARCHIVEENTRY]
ALTER TABLE [dbo].[FileServerVolumeEntry] DROP CONSTRAINT [CONS_FK_FILESERVERENTRY_FILESERVERVOLUMEENTRY]
ALTER TABLE [dbo].[FileServerVolumeEntry] DROP CONSTRAINT [CONS_FK_VAULTSTOREENTRY_FILESERVERVOLUMEENTRY]
ALTER TABLE [dbo].[FileServerVolumeEntry] DROP CONSTRAINT [CONS_FK_VOLUMEPOLICYENTRY_FILESERVERVOLUMEENTRY]
ALTER TABLE [dbo].[FileServerVolumeEntry] DROP CONSTRAINT [FK_FileServerVolumeEntry_FileSystemArchivingTask]
ALTER TABLE [dbo].[FileSystemArchivingTask] DROP CONSTRAINT [FK_FileSystemArchivingTask_Task]
ALTER TABLE [dbo].[fg_RuPolicyRulesEntry] DROP CONSTRAINT [FK_fg_RuPolicyRulesEntry_FileGroup]
ALTER TABLE [dbo].[fg_RuPolicyRulesEntry] DROP CONSTRAINT [FK_fg_RuPolicyRulesEntry_RuPolicyRulesEntry]
ALTER TABLE [dbo].[FileSystemPruningTask] DROP CONSTRAINT [FK_FileSystemPruningTask_FileSystemArchivingTask]
ALTER TABLE [dbo].[FileSystemPruningTask] DROP CONSTRAINT [FK_FileSystemPruningTask_Task]
ALTER TABLE [dbo].[FileSystemSynchronizationTask] DROP CONSTRAINT [FK_FileSystemSynchronizationTask_FileSystemArchivingTask]
ALTER TABLE [dbo].[FileSystemSynchronizationTask] DROP CONSTRAINT [FK_FileSystemSynchronizationTask_Task]
ALTER TABLE [dbo].[FileServerRetentionPolicyRule] DROP CONSTRAINT [FK_RetentionPolicyRule_FolderPolicyEntry]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_FILTERENTRY]
ALTER TABLE [dbo].[FileServerRetentionTarget] DROP CONSTRAINT [FK_FileServerRetentionTargetEntry_FileServerVolumeEntry]
ALTER TABLE [dbo].[FileServerRetentionTarget] DROP CONSTRAINT [FK_FileServerRetentionTarget_RetentionPolicyEntry]
ALTER TABLE [dbo].[FolderPolicyEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_FOLDERPOLICYENTRY]
ALTER TABLE [dbo].[FileServerRetentionTargetFSFolderMapping] DROP CONSTRAINT [FK_FileServerRetentionTargetFSFolderMapping_FileServerFolderEntry]
ALTER TABLE [dbo].[FileServerRetentionTargetFSFolderMapping] DROP CONSTRAINT [FK_FileServerRetentionTargetFSFolderMapping_RetentionPolicyRule]
ALTER TABLE [dbo].[FileServerRetentionTargetFSFolderMapping] DROP CONSTRAINT [FK_FileServerRetentionTargetFSFolderMapping_FileServerRetentionTarget]
ALTER TABLE [dbo].[MonitoringSettings] DROP CONSTRAINT [FK_MonitoringSettings_SiteEntry]
ALTER TABLE [dbo].[FileServerRetentionTargetSubFolder] DROP CONSTRAINT [FK_FileServerRetentionTargetSubFolder_FileServerRetentionTarget]
ALTER TABLE [dbo].[IndexRootPathEntry] DROP CONSTRAINT [CONS_FK_INDEXINGSERVICEENTRY_INDEXROOTPATHENTRY]
ALTER TABLE [dbo].[FileServerRetentionTargetSubfolderFSFolderMapping] DROP CONSTRAINT [FK_FileServerRetentionTargetSubfolderFSFolderMapping_FileServerRetentionTargetFSFolderMapping]
ALTER TABLE [dbo].[FileServerRetentionTargetSubfolderFSFolderMapping] DROP CONSTRAINT [FK_FileServerRetentionTargetSubfolderFSFolderMapping_FileServerRetentionTargetSubFolder]
ALTER TABLE [dbo].[IndexVolume] DROP CONSTRAINT [FK_Index_IndexRootPathEntry]
ALTER TABLE [dbo].[IndexVolume] DROP CONSTRAINT [FK_Index_Root]
ALTER TABLE [dbo].[RetentionPolicy] DROP CONSTRAINT [FK_RetentionPolicy_PolicyEntry]
ALTER TABLE [dbo].[IndexingServiceEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_INDEXINGSERVICEENTRY]
ALTER TABLE [dbo].[IndexingServiceEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_INDEXINGSERVICEENTRY]
ALTER TABLE [dbo].[RetentionPolicyRuleMapping] DROP CONSTRAINT [FK_RetentionPolicyRuleMapping_RetentionPolicyRule]
ALTER TABLE [dbo].[RetentionPolicyRuleMapping] DROP CONSTRAINT [FK_RetentionPolicyRuleMapping_RetentionPolicy]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [FK_JournalTask_ExchangeServerEntry]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [FK_JournalTask_Task]
ALTER TABLE [dbo].[FileSystemCelerraDelOnDelTask] DROP CONSTRAINT [FK_FileSystemCelerraDelOnDelTask_Task]
ALTER TABLE [dbo].[FileSystemCelerraDelOnDelTask] DROP CONSTRAINT [FK_FileSystemCelerraDelOnDelTask_FileSystemArchivingTask]
ALTER TABLE [dbo].[JournalingTarget] DROP CONSTRAINT [FK_JournalingTarget_JournalTask]
ALTER TABLE [dbo].[JournalingTarget] DROP CONSTRAINT [FK_JournalingTarget_ExchangeMailboxEntry]
ALTER TABLE [dbo].[JournalingTarget] DROP CONSTRAINT [FK_JournalingTarget_PolicyEntry]
ALTER TABLE [dbo].[JournalingTarget] DROP CONSTRAINT [FK_JournalingTarget_RetentionCategoryEntry]
ALTER TABLE [dbo].[Monitoring] DROP CONSTRAINT [FK_Monitoring_SiteEntry]
ALTER TABLE [dbo].[NetAppPlaceholderComputerEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_NETAPPPLACEHOLDERFILESERVERENTRY]
ALTER TABLE [dbo].[NetAppPlaceholderComputerEntry] DROP CONSTRAINT [CONS_FK_FILESERVERENTRY_NETAPPPLACEHOLDERFILESERVERENTRY]
ALTER TABLE [dbo].[NotesDomainEntry] DROP CONSTRAINT [FK_NotesDomainEntry_SiteEntry]
ALTER TABLE [dbo].[NotesJournalMailboxEntry] DROP CONSTRAINT [FK_NotesJournalMailboxEntry_NotesJournalingTask]
ALTER TABLE [dbo].[NotesJournalMailboxEntry] DROP CONSTRAINT [FK_NotesJournalMailboxEntry_NotesMailServerEntry]
ALTER TABLE [dbo].[NotesJournalMailboxEntry] DROP CONSTRAINT [FK_NotesJournalMailboxEntry_PolicyEntry]
ALTER TABLE [dbo].[NotesJournalMailboxEntry] DROP CONSTRAINT [FK_NotesJournalMailboxEntry_RetentionCategoryEntry]
ALTER TABLE [dbo].[NotesJournalMailboxEntry] DROP CONSTRAINT [FK_NotesJournalMailboxEntry_Root]
ALTER TABLE [dbo].[VaultStoreGroup] DROP CONSTRAINT [FK_VaultStoreGroup_SiteEntry]
ALTER TABLE [dbo].[NotesJournalingTask] DROP CONSTRAINT [FK_NotesJournalingTask_Task]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [FK_NotesMailserverEntry_VaultStoreEntry]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [FK_NotesMailserverEntry_IndexingServiceEntry]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [FK_NotesMailServerEntry_NotesDomainEntry]
ALTER TABLE [dbo].[SISBoundary] DROP CONSTRAINT [FK_SISBoundary_VaultStoreGroupIdentity]
ALTER TABLE [dbo].[Organization] DROP CONSTRAINT [FK_Organization_SiteEntry]
ALTER TABLE [dbo].[PSTPolicySettings] DROP CONSTRAINT [FK_PSTPolicySettings_PolicyEntry]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [FK_HSMType_HSMTypeEntry]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [FK_PartitionEntry_VaultStoreEntry]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [FK_SecondaryLocation_Locations]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [FK_AltSecondaryLocation1_Locations]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [FK_AltSecondaryLocation2_Locations]
ALTER TABLE [dbo].[FingerprintCatalogueInstance] DROP CONSTRAINT [FK_FingerprintCatalogueInstance_VaultStoreGroupIdentity]
ALTER TABLE [dbo].[ExchangeMbxArchiveFolder] DROP CONSTRAINT [FK_RootArchiveFolderIdentity]
ALTER TABLE [dbo].[PhPolicySettingsEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_PHPOLICYSETTINGSENTRY]
ALTER TABLE [dbo].[PolicyEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_POLICYENTRY]
ALTER TABLE [dbo].[PstCollectorTask] DROP CONSTRAINT [FK_PSTCollectorTask_Task]
ALTER TABLE [dbo].[FingerprintCatalogueDatabase] DROP CONSTRAINT [FK_FingerprintCatalogueDatabase_FingerprintCatalogueInstance]
ALTER TABLE [dbo].[PstDomain] DROP CONSTRAINT [FK_PSTDomain_SiteEntry]
ALTER TABLE [dbo].[PstFile] DROP CONSTRAINT [FK_PstFile_PstComputer]
ALTER TABLE [dbo].[PstLocatorTask] DROP CONSTRAINT [FK_PstLocatorTask_Task]
ALTER TABLE [dbo].[PstMigrationHistory] DROP CONSTRAINT [FK_PstMigrationHistory_PstFile]
ALTER TABLE [dbo].[ArchiveMoveHistory] DROP CONSTRAINT [FK_ArchiveMoveHistory_ArchiveHistory]
ALTER TABLE [dbo].[PstMigratorTask] DROP CONSTRAINT [FK_PstMigratorTask_Task]
ALTER TABLE [dbo].[PublicFolderTarget] DROP CONSTRAINT [FK_PublicFolderTarget_PublicFolderTask]
ALTER TABLE [dbo].[PublicFolderTarget] DROP CONSTRAINT [FK_PublicFolderTarget_VaultStoreEntry]
ALTER TABLE [dbo].[PublicFolderTarget] DROP CONSTRAINT [FK_PublicFolderTarget_PolicyEntry]
ALTER TABLE [dbo].[PublicFolderTask] DROP CONSTRAINT [FK_PublicFolderTask_ExchangeServerEntry]
ALTER TABLE [dbo].[PublicFolderTask] DROP CONSTRAINT [FK_PublicFolderTask_Task]
ALTER TABLE [dbo].[VaultInterest] DROP CONSTRAINT [FK_VaultInterest_VaultEntryId]
ALTER TABLE [dbo].[QuoPolicySettingsEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_QUOPOLICYSETTINGSENTRY]
ALTER TABLE [dbo].[FileServerRestoreFolders] DROP CONSTRAINT [CONS_FK_FILESERVERENTRY_FILESERVERRESTOREFOLDERS]
ALTER TABLE [dbo].[RcPolicySettingsEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_RCPOLICYSETTINGSENTRY]
ALTER TABLE [dbo].[RcPolicySettingsEntry] DROP CONSTRAINT [CONS_FK_RETENTIONCATEGORYENTRY_RCPOLICYSETTINGSENTRY]
ALTER TABLE [dbo].[RetentionCategoryEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_RETENTIONCATEGORYENTRY]
ALTER TABLE [dbo].[RetentionCategoryEntry] DROP CONSTRAINT [FK_RetentionCategoryEntry_ExchangeManagedContentSetting]
ALTER TABLE [dbo].[RetrievalTask] DROP CONSTRAINT [FK_RetrievalTask]
ALTER TABLE [dbo].[RetrievalTask] DROP CONSTRAINT [FK_RetrievalTask_ExchangeServerEntry]
ALTER TABLE [dbo].[RegisteredClientMailboxes] DROP CONSTRAINT [FK_RegisteredClientMailboxes_MailboxEntryId]
ALTER TABLE [dbo].[Root] DROP CONSTRAINT [FK_Root_Root]
ALTER TABLE [dbo].[Root] DROP CONSTRAINT [FK_Root_Trustee]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_RUPOLICYRULESENTRY]
ALTER TABLE [dbo].[FBActionMessages] DROP CONSTRAINT [FK_FBActionMessages_SiteEntry]
ALTER TABLE [dbo].[SPSServiceEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_SPSSERVICEENTRY]
ALTER TABLE [dbo].[SPSServiceEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_SPSSERVICEENTRY]
ALTER TABLE [dbo].[FileServerNodeProps] DROP CONSTRAINT [FK_FileServerNodePropsKey_SiteEntry]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [CONS_FK_RETENTIONCATEGORYENTRY_SPSWORKSPACEENTRY]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_SPSWORKSPACEENTRY]
ALTER TABLE [dbo].[SettingType] DROP CONSTRAINT [FK_SettingType_SettingSection]
ALTER TABLE [dbo].[SharePointPathTarget] DROP CONSTRAINT [FK_SharePointPathTarget_RetentionCategoryEntry]
ALTER TABLE [dbo].[SharePointPathTarget] DROP CONSTRAINT [FK_SharePointPathTarget_SharePointPolicyEntry]
ALTER TABLE [dbo].[SharePointPathTarget] DROP CONSTRAINT [FK_SharePointPathTarget_SharePointTLSTarget]
ALTER TABLE [dbo].[TraceEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_TRACEENTRY]
ALTER TABLE [dbo].[SharePointPolicyEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_SHAREPOINTPOLICYENTRY]
ALTER TABLE [dbo].[SharePointServerEntry] DROP CONSTRAINT [FK_SharePointServerEntry_SharePointTask]
ALTER TABLE [dbo].[SharePointServerEntry] DROP CONSTRAINT [FK_SharePointServerEntry_RetentionCategoryEntry]
ALTER TABLE [dbo].[SharePointServerEntry] DROP CONSTRAINT [FK_SharePointServerEntry_SharePointPolicyEntry]
ALTER TABLE [dbo].[SharePointServerEntry] DROP CONSTRAINT [FK_SharePointServerEntry_VaultStoreEntry]
ALTER TABLE [dbo].[SharePointTLSTarget] DROP CONSTRAINT [FK_SharePointTLSTarget_SharePointTask]
ALTER TABLE [dbo].[SharePointTLSTarget] DROP CONSTRAINT [FK_SharePointTLSTarget_RetentionCategoryEntry]
ALTER TABLE [dbo].[SharePointTLSTarget] DROP CONSTRAINT [FK_SharePointTLSTarget_Root]
ALTER TABLE [dbo].[SharePointTLSTarget] DROP CONSTRAINT [FK_SharePointTLSTarget_SharePointPolicyEntry]
ALTER TABLE [dbo].[SharePointTLSTarget] DROP CONSTRAINT [FK_SharePointTLSTarget_SharePointServerEntry]
ALTER TABLE [dbo].[SdPolicySettingsEntry] DROP CONSTRAINT [FK_SdPolicySettingsEntry_PolicyEntry]
ALTER TABLE [dbo].[SharePointTask] DROP CONSTRAINT [FK_SharePointTask_Task]
ALTER TABLE [dbo].[EVDominoServer] DROP CONSTRAINT [FK_EVDominoServer_NotesDomainEntry]
ALTER TABLE [dbo].[EVDominoServer] DROP CONSTRAINT [FK__EVDominoS__Compu__3F865F66]
ALTER TABLE [dbo].[SpPolicyRulesMetadataEntry] DROP CONSTRAINT [FK_SpPolicyRulesMetadataEntry_SpPolicyRulesEntry]
ALTER TABLE [dbo].[ShoppingServiceEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_SHOPPINGSERVICEENTRY]
ALTER TABLE [dbo].[ShoppingServiceEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_SHOPPINGSERVICEENTRY]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [CONS_FK_DIRECTORY_SITEENTRY]
ALTER TABLE [dbo].[SpPolicyRulesEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_SPPOLICYRULESENTRY]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_SPPRPOLICYSETTINGSENTRY]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_STORAGESERVICEENTRY]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_STORAGESERVICEENTRY]
ALTER TABLE [dbo].[NetappFileServerProxy] DROP CONSTRAINT [FK_NetappFileServerProxy_NetappProxy]
ALTER TABLE [dbo].[NetappFileServerProxy] DROP CONSTRAINT [FK_NetappFileServerProxy_NetappServer]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [FK_Task_ComputerEntry]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [FK_Task_SiteEntry]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [FK_Task_UserData]
ALTER TABLE [dbo].[TaskControllerServiceEntry] DROP CONSTRAINT [CONS_FK_COMPUTERENTRY_TASKCONTROLLERSERVICEENTRY]
ALTER TABLE [dbo].[TaskControllerServiceEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_TASKCONTROLLERSERVICEENTRY]
ALTER TABLE [dbo].[DominoMailboxArchivingTask] DROP CONSTRAINT [FK_DominoMailboxArchivingTask_Task]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [FK_VaultStoreEntry_SISBoundary]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [CONS_FK_STORAGESERVICEENTRY_VAULTSTOREENTRY]
ALTER TABLE [dbo].[FSAReportingWSLocations] DROP CONSTRAINT [FK_FSAReportingWSLocations_SiteEntryId]
ALTER TABLE [dbo].[VolumePolicyEntry] DROP CONSTRAINT [CONS_FK_POLICYENTRY_VOLUMEPOLICYENTRY]
ALTER TABLE [dbo].[DominoMailboxPolicySyncTask] DROP CONSTRAINT [FK_DominoMailboxPolicySyncTask_Task]
ALTER TABLE [dbo].[DominoMailboxPolicySyncTask] DROP CONSTRAINT [FK_DominoMailboxPolicySyncTask_NotesDomainEntry]
ALTER TABLE [dbo].[FSAReportingSite] DROP CONSTRAINT [FK_FSAReportingSite_SiteEntryId]
ALTER TABLE [dbo].[FSAReportingSite] DROP CONSTRAINT [FK_FSAReportingSite_FSAReportingConfigurationId]
ALTER TABLE [dbo].[MonitoringHistory] DROP CONSTRAINT [FK_MonitoringHistory_Monitoring]
ALTER TABLE [dbo].[ExchangePolicySyncTask] DROP CONSTRAINT [FK_ExchangePolicySyncTask_Task]
ALTER TABLE [dbo].[ExchangePolicySyncTask] DROP CONSTRAINT [FK_DominoMailboxPolicySyncTask_Organization]
ALTER TABLE [dbo].[FSAReportingMappings] DROP CONSTRAINT [FK_FSAReportingMappings_FileServerEntryId]
ALTER TABLE [dbo].[FSAReportingMappings] DROP CONSTRAINT [FK_FSAReportingMappings_FSAReportingDatabaseId]
ALTER TABLE [dbo].[FSAReportingMappings] DROP CONSTRAINT [FK_FSAReportingMappings_FSAReportingSiteId]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [FK_DominoMaiboxEntry_PolicyEntry]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [FK_DominoMaiboxEntry_ComputerEntry]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [FK_DominoMaiboxEntry_NotesMailServerEntry]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [FK_DominoMailboxEntry_PolicyTargetMember]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [FK_DominoMailboxEntry_SubTask]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [FK_DominoMaiboxEntry_PolicyTargetEntryId]
ALTER TABLE [dbo].[CacheReplacmentSettings] DROP CONSTRAINT [FK_CacheReplacmentSettings_FileServerEntry]
ALTER TABLE [dbo].[FSAReportingProxyServerMappings] DROP CONSTRAINT [FK_FSAReportingProxyServerMappings_FileServerEntryId]
ALTER TABLE [dbo].[FSAReportingProxyServerMappings] DROP CONSTRAINT [FK_FSAReportingProxyServerMappings_FSAReportingProxyServerId]
ALTER TABLE [dbo].[ldRuPolicyEntry] DROP CONSTRAINT [FK_ldRuPolicyEntry_PolicyEntry]
ALTER TABLE [dbo].[ReportServerURLSettings] DROP CONSTRAINT [FK_ReportServerURLSettings_ReportServerURLIdentity]
ALTER TABLE [dbo].[ldScPolicySettingsEntry] DROP CONSTRAINT [FK_ldScPolicySettingsEntry_PolicyEntry]
ALTER TABLE [dbo].[RetentionCategoryMappings] DROP CONSTRAINT [CONS_FK_RetentionCategoryMappings_SiteEntry]
ALTER TABLE [dbo].[RetentionCategoryMappings] DROP CONSTRAINT [CONS_FK_RetentionCategoryMappings_RetentionCategoryEntry]
ALTER TABLE [dbo].[PolicyTargetGroup] DROP CONSTRAINT [FK_PolicyTargetGroup_VaultStoreEntry]
ALTER TABLE [dbo].[PolicyTargetGroup] DROP CONSTRAINT [FK_PolicyTargetGroup_IndexingServiceEntry]
ALTER TABLE [dbo].[PolicyTargetGroup] DROP CONSTRAINT [FK_PolicyTargetGroup_RetentionCategoryEntry]
ALTER TABLE [dbo].[PolicyTargetGroup] DROP CONSTRAINT [FK_PolicyTargetGroup_PolicyEntry]
ALTER TABLE [dbo].[SubTask] DROP CONSTRAINT [FK_SubTask_Task]
ALTER TABLE [dbo].[PolicyTargetMember] DROP CONSTRAINT [FK_PolicyTargetMember_PolicyTargetGroup]
ALTER TABLE [dbo].[ExchangePolicyTargetGroup] DROP CONSTRAINT [FK_ExchangePolicyTargetGroup_PolicyTargetGroup]
ALTER TABLE [dbo].[ExchangePolicyTargetGroup] DROP CONSTRAINT [FK_ExchangePolicyTargetGroup_Organization]
ALTER TABLE [dbo].[ExchangePolicyTargetGroup] DROP CONSTRAINT [FK_ExchangePolicyTargetGroup_PolicyEntry]
ALTER TABLE [dbo].[DominoPolicyTargetGroup] DROP CONSTRAINT [FK_DominoPolicyTargetGroup_PolicyTargetGroup]
ALTER TABLE [dbo].[DominoPolicyTargetGroup] DROP CONSTRAINT [FK_DominoPolicyTargetGroup_NotesDomainEntry]
ALTER TABLE [dbo].[DominoACE] DROP CONSTRAINT [FK_DominoACE_Root]
ALTER TABLE [dbo].[DominoACE] DROP CONSTRAINT [FK_DominoACE_DominoTrustee]
ALTER TABLE [dbo].[ExchangeMailboxStore] DROP CONSTRAINT [FK_ExchangeMailboxStore_ExchangeServerIdentity]
ALTER TABLE [dbo].[FileBlockingAction] DROP CONSTRAINT [FK_FileBlockingAction_FileBlockingRule]
ALTER TABLE [dbo].[ACE] DROP CONSTRAINT [FK_ACE_Root]
ALTER TABLE [dbo].[ACE] DROP CONSTRAINT [FK_ACE_Trustee]
ALTER TABLE [dbo].[MessageClassLink] DROP CONSTRAINT [FK_MessageClassLink_MessageClassEntry]
ALTER TABLE [dbo].[MessageClassLink] DROP CONSTRAINT [FK_MessageClassLink_PolicyEntry]
ALTER TABLE [dbo].[AdminJobEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_ADMINJOBENTRY]
ALTER TABLE [dbo].[AgentServiceEntry] DROP CONSTRAINT [CONS_FK_SITEENTRY_AGENTSERVICEENTRY]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [FK_Archive_Root]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [FK_Archive_VaultStoreEntry]
-- DROP FK passed
-- ***
-- DROP DEFAULT CONSTRAINTS
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [DF_ExchangeServerEntry_OverrideFlags]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [DEF_DriverTransFlag]
ALTER TABLE [dbo].[RetrievalTask] DROP CONSTRAINT [DF_RetrievalTask_ProblemPauseInterval]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [DEF_FileBlockingRule_LastUpdatedUTC]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_ArchiveLimitSize]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [DEF_AllowedFileTypesFlag_FALSE]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_ArchiveLimitOperation]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [DF_SPSWorkspaceEntry_ArchiveEnhancedFolders]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_ArchiveLimitStatus]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [DF_SPSWorkspaceEntry_IndexShortcuts]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_ArchiveNotifyOperation]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [DF_SPSWorkspaceEntry_ArchiveImmediately]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_ArchiveNotifySize]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [DF_SPSWorkspaceEntry_LeaveShortcuts]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_DeleteExpiredItems]
ALTER TABLE [dbo].[FileGroup] DROP CONSTRAINT [DEFAULT_FILEGROUP_TYPE]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [DF_SPSWorkspaceEntry_PruneEnhancedFolders]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_DeleteProtected]
ALTER TABLE [dbo].[FileGroup] DROP CONSTRAINT [DEFAULT_LASTMODIFIED_DATE]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_Structured]
ALTER TABLE [dbo].[FileGroup] DROP CONSTRAINT [DF_FileGroup_IsADefaultFileGroup]
ALTER TABLE [dbo].[SharePointTLSTarget] DROP CONSTRAINT [DF_SharePointTLSTarget_AutoCreated]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_ArchiveFull]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_DeleteExpiredItems]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_IndexItemsMode]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_DeleteProtected]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_ConvertedContentMode]
ALTER TABLE [dbo].[FileGroupFile] DROP CONSTRAINT [DF_FILEGROUP_INCLUDE_FLAG_IS_ZERO]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_DefaultPublicFolderSchedule]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_IgnoreIndexingPolicy]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_DefaultExpirySchedule]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_AgentClientBrokerTraceLevel]
ALTER TABLE [dbo].[PSTPolicySettings] DROP CONSTRAINT [DF_PSTPolicySettings_pstDefineCustomProperties]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_DesktopDoubleClickView]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_NumberOfEnabledMailboxes]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_ExpiryDateBasis]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_MaxNoOfMsgsPerPass]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_ExpiryReportMode]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_SynchronizeAM]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SiteAccountDistinguishedName]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_SynchronizeAMTime]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SiteAccountMailBoxAlias]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_SynchronizePM]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_SynchronizePMTime]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SiteDirectoryEntryId]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [DF_ArchivingRetrievalTask_ProblemPauseInterval]
ALTER TABLE [dbo].[DirectoryEntry] DROP CONSTRAINT [DF__Directory__AzSto__147C05D0]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SiteVaultLimitSize]
ALTER TABLE [dbo].[ComputerEntry] DROP CONSTRAINT [DF_ComputerEntry_SvcNamesUpgradeState]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SiteVaultLimitOperation]
ALTER TABLE [dbo].[DirectoryEntry] DROP CONSTRAINT [DF_Directory_TaskUpgradeState]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_IndexMode]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_AllClientsAtSiteVersion]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_City]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_DefaultPFRetentionCategoryId]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_Company]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SPSExcludeFileTypes]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_Country]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SPSItemSize]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_Department]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SiteVaultNotifyOperation]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_Password]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_EmployeeType]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_SiteVaultNotifySize]
ALTER TABLE [dbo].[IndexingServiceEntry] DROP CONSTRAINT [DF_IndexingServiceEntry_NumberOfIndexingLocations]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_FirstName]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_QuotaNotificationFreq]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_LastName]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_CreateStructuredArchives]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_Office]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_EnableCodeMonitoring]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_State]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_PSTHoldingLimit]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_Title]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_SpPrPolicySettingsEntry_RemoveOldItems]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_UseQuota]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_SpPrPolicySettingsEntry_RemovePeriod]
ALTER TABLE [dbo].[FileSystemCelerraDelOnDelTask] DROP CONSTRAINT [DF__FileSyste__Repor__22CA2527]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_SpPrPolicySettingsEntry_RemoveUnit]
ALTER TABLE [dbo].[FileSystemCelerraDelOnDelTask] DROP CONSTRAINT [DF__FileSyste__Archi__23BE4960]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_FileWatchScanFrequency]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_StorageManage]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ArchiveOperations]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_BackupMode]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_BypassConversions]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_PhSvrNumberOfThreads]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ConversionTimeout]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_PhSvrRecallLimitTimeInterval]
ALTER TABLE [dbo].[SharePointTask] DROP CONSTRAINT [DF_SharePoint_ShortcutDeletionRunTime]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ExcludedFileTypes]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF__Archive__HasHist__2917FB5A]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_PhSvrRecallLimitMaxRecalls]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ThrottlingDisabled]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_PhSvrBypassRecallLimitsForAdmins]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ThrottleInterval]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_SharingLevel]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_FileServerType]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ThrottleLowerThreshold]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_SharingOccured]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_FileServerVersion]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [DF__NotesMail__Clust__2C738AF2]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ThrottleUpperThreshold]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_BlockLevelSharing]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [DF__NotesMail__Prefe__2D67AF2B]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_MaxMSMSQMessageSize]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_DeviceCompression]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF__FileServe__Delet__2E5BD364]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_MSMQTimeout]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_DeviceLevelSharing]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_MSMQNackClearInterval]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_ExtendableRetention]
ALTER TABLE [dbo].[FileSystemArchivingTask] DROP CONSTRAINT [DF__FileSyste__Ignor__4A18FC72]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ExpirySchedule]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_RolloverOrder]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_ExpiryReportMode]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_RolloverType]
ALTER TABLE [dbo].[ArchiveFolder] DROP CONSTRAINT [DF__ArchiveFo__Delet__31AD415B]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF__SiteEntry__Dumps__322C6448]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_MaxConcurrentMigrations]
ALTER TABLE [dbo].[VaultStoreGroup] DROP CONSTRAINT [DF_VaultStoreGroup_Description]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_ArchiveLock]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF__SiteEntry__Dumps__33208881]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_TextConversionFileTypes]
ALTER TABLE [dbo].[FileSystemArchivingTask] DROP CONSTRAINT [DF_FileSystemArchivingTask_CheckPointFolder]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_ShortcutInactivityPeriod]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [DF_Task_UseSiteSchedule]
ALTER TABLE [dbo].[FileSystemArchivingTask] DROP CONSTRAINT [DF_FileSystemArchivingTask_UseCheckPointing]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_ShortcutInactivityUnits]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [DF_TASK_NumberOfThreads]
ALTER TABLE [dbo].[RegisteredClientMailboxes] DROP CONSTRAINT [DF_RegisteredClientMailboxes_RegistrationDate]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_RestoredItemsInactivtyPeriod]
ALTER TABLE [dbo].[FileServerNodeProps] DROP CONSTRAINT [DEF_FSNodeProps_CurrentDateUTC]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [DF_Task_RetryCount]
ALTER TABLE [dbo].[RegisteredClientMailboxes] DROP CONSTRAINT [DF_RegisteredClientMailboxes_LastRegistrationDate]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_RestoredItemsInactivtyUnits]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [DF__Task__StartupType]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_AllowSubFolderInheritance]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_LastModified_UTC]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_DeleteExpiredItems]
ALTER TABLE [dbo].[RetentionCategoryEntry] DROP CONSTRAINT [DF_RetentionCategoryEntry_ExpiryDateBasis2]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_LockSubFolderInheritance]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_VaultStoreStatus]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_AMinAgeLargeItems]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_VaultStoreVaultLimitSize]
ALTER TABLE [dbo].[ExchangeManagedContentSetting] DROP CONSTRAINT [DF_ExchangeManagedContentSetting_EVUpdate]
ALTER TABLE [dbo].[SpPolicyRulesEntry] DROP CONSTRAINT [DF__SpPolicyR__Conte__3A42875C]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_AMinAgeLargeItemsUnits]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DEF_FSE_InstallDateUTC]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_VaultStoreVaultLimitOperation]
ALTER TABLE [dbo].[DirectoryEntry] DROP CONSTRAINT [DF_DirectoryEntry_EncryptionVersion]
ALTER TABLE [dbo].[SpPolicyRulesEntry] DROP CONSTRAINT [DF__SpPolicyR__Conte__3B36AB95]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_AMinSizeLargeItems]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DEF_FSE_InstallDate_Minus_OneUTC]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_VaultStoreType]
ALTER TABLE [dbo].[IndexRootPathEntry] DROP CONSTRAINT [DF_IndexRootPathEntry_BackupMode]
ALTER TABLE [dbo].[SpPolicyRulesEntry] DROP CONSTRAINT [DF__SpPolicyR__Metad__3C2ACFCE]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_ASizePriority]
ALTER TABLE [dbo].[SdPolicySettingsEntry] DROP CONSTRAINT [DF_SdPolicySettingsEntry_ShortcutInactivityPeriod]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_CatalogueEntryId]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ArchiveEnabled]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_QMinAgeThresholdPeriod]
ALTER TABLE [dbo].[SdPolicySettingsEntry] DROP CONSTRAINT [DF_SdPolicySettingsEntry_ShortcutInactivityUnits]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_SQLServer]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ArchiveUnits]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_QMinAgeThresholdUnits]
ALTER TABLE [dbo].[SdPolicySettingsEntry] DROP CONSTRAINT [DF_SdPolicySettingsEntry_OrphanedShortcutRun]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_SQLProtocol]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ArchivePeriod]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_QMinSizeLargeItems]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_SQLDSNType]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ArchiveOp]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_FullSyncSlots]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_QSizePriority]
ALTER TABLE [dbo].[PhPolicySettingsEntry] DROP CONSTRAINT [DF__PhPolicyS__phDel__407A839F]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_DatabaseName]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_AccessEnabled]
ALTER TABLE [dbo].[FileSystemArchivingTask] DROP CONSTRAINT [DF_FileSystemArchivingTask_ChkPointingSnapshotInterval1]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_ExpandDistLists]
ALTER TABLE [dbo].[Monitoring] DROP CONSTRAINT [DF_Monitoring_Hidden]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_ShortcutInactivityPeriod]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_VaultStoreVaultNotifyOperation]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_AccessUnits]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_SCMoveMoveUpdateRetCatUserII]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_ExpandDistListsLock]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_RemoveOldShortcuts]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_ShortcutInactivityUnits]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_VaultStoreVaultNotifySize]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_AccessPeriod]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF__Partition__ScanS__42D7CD5D]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF__FilterEnt__Proce__1F2E9E6D]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_RemoveShortcutPeriod]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_OrphanedShortcutRun]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_NoJournalBackup]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_AccessOp]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF__Partition__ScanU__43CBF196]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_RemoveShortcutUnit]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_OrphanedShortcutRun]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ModifyEnabled]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF__Partition__ScanU__44C015CF]
ALTER TABLE [dbo].[IndexVolume] DROP CONSTRAINT [DF_IndVol_Offline]
ALTER TABLE [dbo].[IndexRootPathEntry] DROP CONSTRAINT [DF_IndexRootPathEntry_BackupModeRefCount]
ALTER TABLE [dbo].[DirectoryEntry] DROP CONSTRAINT [DF__Directory__AzSto__453F38BC]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ModifyUnits]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF__Partition__ScanU__45B43A08]
ALTER TABLE [dbo].[IndexVolume] DROP CONSTRAINT [DF_IndVol_Failed]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_VaultStoreEntry_BackupModeRefCount]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ModifyPeriod]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_SyncSlots1]
ALTER TABLE [dbo].[IndexVolume] DROP CONSTRAINT [DF_IndVol_Rebuilding]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_ModifyOp]
ALTER TABLE [dbo].[ComputerEntry] DROP CONSTRAINT [DF_ComputerEntry_MaxVaultCacheUpdates1]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_CreateEnabled]
ALTER TABLE [dbo].[Monitoring] DROP CONSTRAINT [DF_Monitoring_MonitoringHistoryResults]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_PauseInterval]
ALTER TABLE [dbo].[PolicyEntry] DROP CONSTRAINT [DF_PolicyEntry_LastModified]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_CreateUnits]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_LongPauseInterval]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_CreatePeriod]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_MaxNoOfMsgsPerPass]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [DF_RuPolicyRulesEntry_CreateOp]
ALTER TABLE [dbo].[MonitoringHistory] DROP CONSTRAINT [DF_MonitoringHistory_Success]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_SynchronizeAM]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_SCMoveUpdateItemLocation]
ALTER TABLE [dbo].[MonitoringHistory] DROP CONSTRAINT [DF_MonitoringHistory_StartDateUTC]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_SynchronizeAMTime]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_SynchronizePM]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_SCMoveMoveUpdateRetCat]
ALTER TABLE [dbo].[FileSystemSynchronizationTask] DROP CONSTRAINT [DF_FileSystemSynchronizationTask_DoFIPSUpgrade]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_SynchronizePMTime]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_SECURENOTIFICATION]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_MonitoringStartUTC]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [DF_JournalTask_ProblemPauseInterval]
ALTER TABLE [dbo].[ExchangePolicySyncTask] DROP CONSTRAINT [DF__ExchangeP__Archi__4FD1D5C8]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_DefaultInterval]
ALTER TABLE [dbo].[Monitoring] DROP CONSTRAINT [DF__Monitorin__Start__6BAEFA67]
ALTER TABLE [dbo].[ExchangePolicySyncTask] DROP CONSTRAINT [DF__ExchangeP__Archi__50C5FA01]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [DF_NotesMailServerEntry_UseIDFile]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [DF_SiteEntry_RetainArchiveHistory]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [DF_Archive_RetainArchiveHistory]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_DeleteProtected]
ALTER TABLE [dbo].[CacheReplacmentSettings] DROP CONSTRAINT [DF__CacheRepl__Cache__54D68207]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_ReadOnlyMedia]
ALTER TABLE [dbo].[CacheReplacmentSettings] DROP CONSTRAINT [DF__CacheRepl__Cache__55CAA640]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_WriteOnceMedia]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_OfflineDays]
ALTER TABLE [dbo].[PstComputer] DROP CONSTRAINT [DF_PstComputer_ComputerType]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_FileWatchCheckUserInfo]
ALTER TABLE [dbo].[FileSystemSynchronizationTask] DROP CONSTRAINT [DF_FSASync_ShortcutDeletionRunTime]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_IsUsePassThroughRead]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_DeviceType]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_MailboxType]
ALTER TABLE [dbo].[FileServerVolumeEntry] DROP CONSTRAINT [DF_FileServerVolumeEntry_IsPassThroughReadSupport]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_StagingRootPath]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_IPAddressList]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [DF_StorageServiceEntry_SlotTimeOut]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_PartitionStatus]
ALTER TABLE [dbo].[DominoMailboxArchivingTask] DROP CONSTRAINT [DF_DominoMailboxArchivingTask_MaxNoOfMsgsPerPass]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_PartitionName]
ALTER TABLE [dbo].[SettingType] DROP CONSTRAINT [DF__SettingTy__Custo__5CB79AF1]
ALTER TABLE [dbo].[DominoMailboxPolicySyncTask] DROP CONSTRAINT [DF_DominoMailboxPolicySyncTask_ArchiveReportsEnabled]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_PartitionDescription]
ALTER TABLE [dbo].[DominoMailboxPolicySyncTask] DROP CONSTRAINT [DF_DominoMailboxPolicySyncTask_ArchiveReportLevel]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_TimeCreated]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_City]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_TimeOpened]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_CompanyName]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_TimeClosed]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_country]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [DF_FilterEntry_UseQuotaLimit]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_Reserved]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_Department]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [DF__Task__SubTaskMax__62307D25]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_CollectionStartTime]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_employeeType]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_CollectionStopTime]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_FirstName]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AgeToCollectAlways]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_LastName]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AgeToCollectAlwaysUnits]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_OfficeCity]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [DF_ExchangeMailboxEntry_MbxSuspended]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AgeToDeleteTempRecalls]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_OfficeState]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_IgnoreBackup_PartitionEntry]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_MaxCollectionSize]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_Title]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [DF_SharingHistory_VaultStoreEntry]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_OverrideRetentionPeriod]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AccountName]
ALTER TABLE [dbo].[ldScPolicySettingsEntry] DROP CONSTRAINT [DF_ldScPolicySettingsEntry_ShortcutInactivityPeriod]
ALTER TABLE [dbo].[ldScPolicySettingsEntry] DROP CONSTRAINT [DF_ldScPolicySettingsEntry_ShortcutInactivityPeriodUnits]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_ReplicaIPAddressList]
ALTER TABLE [dbo].[ldScPolicySettingsEntry] DROP CONSTRAINT [DF_ldScPolicySettingsEntry_OrphanedShortcutRun]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_Migrate]
ALTER TABLE [dbo].[ExchangeManagedContentSetting] DROP CONSTRAINT [DF_ExchangeManagedContentSetting_ExchangeOrganizationGUID]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AgeToMigrate]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AgeToMigrateUnits]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AgeToDeletePrimary]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_DisplayName]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [DF_PartitionEntry_AgeToDeletePrimaryUnits]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [DF_DominoMailboxEntry_PersonDocUNID]
ALTER TABLE [dbo].[PhPolicySettingsEntry] DROP CONSTRAINT [DF__PhPolicyS__phDel__4B0D20AB]
ALTER TABLE [dbo].[PstLocatorTask] DROP CONSTRAINT [DF_PstLocatorTask_NetworkSearchMethod]
ALTER TABLE [dbo].[PublicFolderTarget] DROP CONSTRAINT [DF_PublicFolderTarget_AutoCreated]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_ArchiveDraftVersions1]
ALTER TABLE [dbo].[PublicFolderTarget] DROP CONSTRAINT [DF_PublicFolderTarget_ArchiveAutoEnablerRoot]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [DF_spPrPolicySettingsEntry_ArchiveDraftsOnlyIfVisible]
ALTER TABLE [dbo].[PublicFolderTask] DROP CONSTRAINT [DF_PublicFolderTask_PauseInterval]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [DF_NotesMailserverEntry_OverrideFlags]
ALTER TABLE [dbo].[PublicFolderTask] DROP CONSTRAINT [DF_PublicFolderTask_LongPauseInterval]
ALTER TABLE [dbo].[PublicFolderTask] DROP CONSTRAINT [DF_PublicFolder_MaxNoOfMsgsPerPass]
ALTER TABLE [dbo].[PublicFolderTask] DROP CONSTRAINT [DF_PublicFolderTask_ProblemPauseInterval]
ALTER TABLE [dbo].[JournalingTarget] DROP CONSTRAINT [DF_JournalingTarget_AddedToEVUTC]
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [DF_ExchangeServerEntry_AddedToEVUTC]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [DEF_IsEnabled]
ALTER TABLE [dbo].[RetentionCategoryEntry] DROP CONSTRAINT [DF_RetentionCategoryEntry_RetentionCategoryType]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [DEF_ArchiveDepth]
ALTER TABLE [dbo].[RetentionCategoryEntry] DROP CONSTRAINT [DF_RetentionCategoryEntry_Lock]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [DF_FileServerEntry_EnablePlaceHolders]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [DEF_DriverFlag]
ALTER TABLE [dbo].[RetrievalTask] DROP CONSTRAINT [DF_RetrievalTask_AgentClientBrokerTraceLevel]
-- DROP DEFAULT CONSTRAINTS passed
-- ***
-- DROP CHECK CONSTRAINTS
ALTER TABLE [dbo].[RegisteredClientMailboxes] DROP CONSTRAINT [CK_RegisteredClientMailboxes_ClientOSType]
ALTER TABLE [dbo].[RegisteredClientMailboxes] DROP CONSTRAINT [CK_RegisteredClientMailboxes_MailboxServerType]
-- DROP CHECK CONSTRAINTS failed
-- ***
-- DROP INDEXES
DROP INDEX [IX_ParentFolderRootIdentity] ON [dbo].[ArchiveFolder]
DROP INDEX [IX_ArchiveFolderCustomId] ON [dbo].[ArchiveFolder]
DROP INDEX [IX_ArchiveFolder_Deleted] ON [dbo].[ArchiveFolder]
DROP INDEX [IX_ExchangeMailboxEntry_LegacyMbxDN] ON [dbo].[ExchangeMailboxEntry]
DROP INDEX [IX_ExchangeMailboxEntry_DefaultVaultID] ON [dbo].[ExchangeMailboxEntry]
DROP INDEX [IX_ExchangeMailboxEntry_ExchMbxGUID] ON [dbo].[ExchangeMailboxEntry]
ALTER TABLE [dbo].[FileBlockingRuleSettings] DROP CONSTRAINT [Key_FileBlockingRule]
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [UN_ExchangeComputer]
DROP INDEX [IX_ExchangeServerIdentity] ON [dbo].[ExchangeServerEntry]
ALTER TABLE [dbo].[FileServerFolderEntry] DROP CONSTRAINT [Unique_FileServerFolderEntry_VolumeEntryId_FolderPath]
DROP INDEX [IDX_fg_RuPolicyRulesEntry_FileGroupEntryId] ON [dbo].[fg_RuPolicyRulesEntry]
DROP INDEX [IDX_fg_RuPolicyRulesEntry_ruPolicyRulesEntryId] ON [dbo].[fg_RuPolicyRulesEntry]
ALTER TABLE [dbo].[FileSystemPruningTask] DROP CONSTRAINT [IX_FileSystemPruningTask_FileSystemArchivingTaskEntryId]
ALTER TABLE [dbo].[FileSystemSynchronizationTask] DROP CONSTRAINT [IX_FileSystemSynchronizationTask_FileSystemArchivingTaskEntryId]
ALTER TABLE [dbo].[FileServerRetentionTarget] DROP CONSTRAINT [IX_FileServerRetentionTarget]
ALTER TABLE [dbo].[FileServerRetentionTarget] DROP CONSTRAINT [Unique_FileServerRetentionTarget_VolumeEntryId_FolderPath]
ALTER TABLE [dbo].[FileServerRetentionTargetSubFolder] DROP CONSTRAINT [IX_FileServerRetentionTargetSubFolder]
DROP INDEX [IX_RootIdentity] ON [dbo].[IndexVolume]
ALTER TABLE [dbo].[RetentionPolicy] DROP CONSTRAINT [IX_RetentionPolicy]
DROP INDEX [IX_JournalTask_ExchangeServerEntryId] ON [dbo].[JournalTask]
ALTER TABLE [dbo].[FileSystemCelerraDelOnDelTask] DROP CONSTRAINT [IX_FileSystemCelerraDelOnDelTask_FileSystemArchivingTaskEntryId]
DROP INDEX [IX_JournalingTarget_TaskEntryId] ON [dbo].[JournalingTarget]
DROP INDEX [IX_NotesDomainEntry_DomainName] ON [dbo].[NotesDomainEntry]
DROP INDEX [IX_NotesJournalMailboxEntry_TaskEntryId_ArchiveEntryId] ON [dbo].[NotesJournalMailboxEntry]
ALTER TABLE [dbo].[VaultStoreGroup] DROP CONSTRAINT [IX_VaultStoreGroup_VaultStoreGroupEntryId]
DROP INDEX [IX_NotesMailServerEntry_ClusterName] ON [dbo].[NotesMailServerEntry]
DROP INDEX [IX_NotesMailServerEntry_NotesDomainEntryId] ON [dbo].[NotesMailServerEntry]
DROP INDEX [IX_Notification_VaultId_MailboxDN] ON [dbo].[NotificationEntry]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [IX_PartitionEntry]
DROP INDEX [IX_PstCollectorTask_TaskEntryId] ON [dbo].[PstCollectorTask]
DROP INDEX [IX_PstComputerName_DomainName] ON [dbo].[PstComputer]
DROP INDEX [IX_DomName] ON [dbo].[PstDomain]
DROP INDEX [IX_PstDomain_SiteEntryId] ON [dbo].[PstDomain]
DROP INDEX [IX_FileSpecification] ON [dbo].[PstFile]
DROP INDEX [IX_MigrationStatus] ON [dbo].[PstFile]
DROP INDEX [IX_ArchiveHistory_VaultEntryId] ON [dbo].[ArchiveHistory]
DROP INDEX [IX_ArchiveHistory_VaultStoreEntryId] ON [dbo].[ArchiveHistory]
DROP INDEX [IX_PstFileEntryId] ON [dbo].[PstMigrationHistory]
DROP INDEX [IX_PublicFolderTarget_TaskEntryId] ON [dbo].[PublicFolderTarget]
DROP INDEX [IX_PublicFolderTarget_PolicyEntryId] ON [dbo].[PublicFolderTarget]
DROP INDEX [IX_PublicFolderTarget_VaultStoreEntryId] ON [dbo].[PublicFolderTarget]
DROP INDEX [IX_FileServerRestoreFolders_FileServerEntryId] ON [dbo].[FileServerRestoreFolders]
ALTER TABLE [dbo].[RegisteredClientMailboxes] DROP CONSTRAINT [UN_RegisteredClientMailboxes_MailboxEntryId_ClientOSType]
DROP INDEX [IX_VaultEntryId_Type_ContainerRootIdentity] ON [dbo].[Root]
DROP INDEX [IX_VaultEntryId] ON [dbo].[Root]
DROP INDEX [IX_ContainerRootIdentity] ON [dbo].[Root]
DROP INDEX [IX_ContainerRootIdentity_RootIdentity_Type] ON [dbo].[Root]
DROP INDEX [IX_Root_TypeINC] ON [dbo].[Root]
DROP INDEX [IX_settingSectionId] ON [dbo].[SettingType]
DROP INDEX [IX_TraceJobEntry_TraceSearch] ON [dbo].[TraceEntry]
DROP INDEX [IX_SharePointServerEntry_TaskEntryId] ON [dbo].[SharePointServerEntry]
DROP INDEX [IX_SharePointTLSTarget_TaskEntryId] ON [dbo].[SharePointTLSTarget]
DROP INDEX [IDX_TASK_TASKIDENTITY] ON [dbo].[Task]
DROP INDEX [IX_SID] ON [dbo].[Trustee]
DROP INDEX [IX_MonitoringHistory_MItemEntryId_EntityEntryId_SDate] ON [dbo].[MonitoringHistory]
DROP INDEX [IDX_FSAReportingMappings_FSAReportingDatabaseId] ON [dbo].[FSAReportingMappings]
DROP INDEX [IX_DominoMailboxEntry_DefaultArchiveEntryId] ON [dbo].[DominoMailboxEntry]
DROP INDEX [IX_DominoMailboxEntry_NotesMailServerEntryId] ON [dbo].[DominoMailboxEntry]
DROP INDEX [IX_DominoMailboxEntry_MbxFullName] ON [dbo].[DominoMailboxEntry]
DROP INDEX [IX_DominoMailboxEntry_LastSynchronized] ON [dbo].[DominoMailboxEntry]
DROP INDEX [IX_DominoMailboxEntry_StorageComputerEntryIdMbxIdentityMbxState] ON [dbo].[DominoMailboxEntry]
DROP INDEX [IX_ReportServerURLSettings_ReportSettingIdentity] ON [dbo].[ReportServerURLSettings]
ALTER TABLE [dbo].[RetentionCategoryMappings] DROP CONSTRAINT [Unique_RetentionCategoryMappings_SourceRetCatEntryId_DestinationRetCatEntryId]
DROP INDEX [IX_PolicyTargetGroup_VaultStoreEntryId] ON [dbo].[PolicyTargetGroup]
DROP INDEX [IX_PolicyTargetGroup_IndexingServiceEntryId] ON [dbo].[PolicyTargetGroup]
DROP INDEX [IX_PolicyTargetGroup_RetentionCategoryId] ON [dbo].[PolicyTargetGroup]
DROP INDEX [IX_PolicyTargetGroup_PolicyEntryId] ON [dbo].[PolicyTargetGroup]
DROP INDEX [IDX_SUBTASK_SUBTASKIDENTITY] ON [dbo].[SubTask]
DROP INDEX [IDX_SUBTASK_TASKIDENTITY] ON [dbo].[SubTask]
DROP INDEX [IX_PolicyTargetMember_PolicyTargetGroupEntryId] ON [dbo].[PolicyTargetMember]
DROP INDEX [IX_ExchangePolicyTargetGroup_OrganizationEntryId] ON [dbo].[ExchangePolicyTargetGroup]
DROP INDEX [IX_FileSpecification] ON [dbo].[FileSpecification]
DROP INDEX [IX_DominoPolicyTargetGroup_DominoDomainEntryId] ON [dbo].[DominoPolicyTargetGroup]
DROP INDEX [IX_DominoTrustee_Name] ON [dbo].[DominoTrustee]
DROP INDEX [IX_DominoACE] ON [dbo].[DominoACE]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [ENTRYID_FileBlockingRule]
DROP INDEX [IX_ACE] ON [dbo].[ACE]
DROP INDEX [IX_MessageClassLink_PolicyID] ON [dbo].[MessageClassLink]
DROP INDEX [IX_VaultStoreEntryId] ON [dbo].[Archive]
DROP INDEX [IX_Archive_ArchiveName] ON [dbo].[Archive]
-- DROP INDEXES passes
-- ***
-- DROP PK
ALTER TABLE [dbo].[ArchiveFolder] DROP CONSTRAINT [PK_ArchiveFolder]
ALTER TABLE [dbo].[ArchivingRetrievalTask] DROP CONSTRAINT [PK_ArchivingRetrievalTask]
ALTER TABLE [dbo].[ComputerEntry] DROP CONSTRAINT [PK___2__10]
ALTER TABLE [dbo].[DirectoryEntry] DROP CONSTRAINT [PK_DirectoryEntry_1__10]
ALTER TABLE [dbo].[FileBlockingRuleFolderFilter] DROP CONSTRAINT [PK_FileBlockingRuleFolderFilter]
ALTER TABLE [dbo].[DnaPolicySettingsEntry] DROP CONSTRAINT [PK_DnaPolicySettingsEntry]
ALTER TABLE [dbo].[ExchangeMailboxEntry] DROP CONSTRAINT [PK_ExchangeMailboxEntry]
ALTER TABLE [dbo].[FileGroup] DROP CONSTRAINT [FileGroup_PK]
ALTER TABLE [dbo].[ExchangePolicySettings] DROP CONSTRAINT [PK_ExchangePolicySettings]
ALTER TABLE [dbo].[ExchangeServerEntry] DROP CONSTRAINT [PK_ExchangeServerEntry]
ALTER TABLE [dbo].[ExtendedSetting] DROP CONSTRAINT [PK_ExtendedSetting]
ALTER TABLE [dbo].[FileServerEntry] DROP CONSTRAINT [PK_FileServerEntry]
ALTER TABLE [dbo].[FileServerFolderEntry] DROP CONSTRAINT [PK_FileServerFolderEntry]
ALTER TABLE [dbo].[FileGroupFile] DROP CONSTRAINT [FileGroupFile_PK]
ALTER TABLE [dbo].[FileServerVolumeArchiveEntry] DROP CONSTRAINT [PK_FileServerVolumeArchiveEntry]
ALTER TABLE [dbo].[FileServerVolumeEntry] DROP CONSTRAINT [PK_FileServerVolumeEntry]
ALTER TABLE [dbo].[FileSystemArchivingTask] DROP CONSTRAINT [PK_FileSystemArchivingTask]
ALTER TABLE [dbo].[FileSystemPruningTask] DROP CONSTRAINT [PK_FileSystemPruningTask]
ALTER TABLE [dbo].[FileSystemSynchronizationTask] DROP CONSTRAINT [PK_FileSystemSynchronizationTask]
ALTER TABLE [dbo].[FileServerRetentionPolicyRule] DROP CONSTRAINT [PK_FileServerRetentionPolicyRule]
ALTER TABLE [dbo].[FilterEntry] DROP CONSTRAINT [PK___11__10]
ALTER TABLE [dbo].[FileServerRetentionTarget] DROP CONSTRAINT [PK_FileServerRetentionTarget]
ALTER TABLE [dbo].[FolderPolicyEntry] DROP CONSTRAINT [PK_FolderPolicyEntry]
ALTER TABLE [dbo].[FileServerRetentionTargetFSFolderMapping] DROP CONSTRAINT [PK_FileServerRetentionTargetFSFolderMapping]
ALTER TABLE [dbo].[HSMTypeEntry] DROP CONSTRAINT [PK_HSMTypeEntry]
ALTER TABLE [dbo].[MonitoringSettings] DROP CONSTRAINT [PK_MonitoringSettings]
ALTER TABLE [dbo].[FileServerRetentionTargetSubFolder] DROP CONSTRAINT [PK_FileServerRetentionTargetSubFolder]
ALTER TABLE [dbo].[IndexRootPathEntry] DROP CONSTRAINT [PK___7__10]
ALTER TABLE [dbo].[FileServerRetentionTargetSubfolderFSFolderMapping] DROP CONSTRAINT [PK_FileServerRetentionTargetSubfolderFSFolderMapping]
ALTER TABLE [dbo].[IndexVolume] DROP CONSTRAINT [PK_IndexVolume]
ALTER TABLE [dbo].[RetentionPolicy] DROP CONSTRAINT [PK_RetentionPolicy]
ALTER TABLE [dbo].[IndexingServiceEntry] DROP CONSTRAINT [PK___6__10]
ALTER TABLE [dbo].[RetentionPolicyRuleMapping] DROP CONSTRAINT [PK_RetentionPolicyRuleMapping]
ALTER TABLE [dbo].[JournalTask] DROP CONSTRAINT [PK_JournalTask]
ALTER TABLE [dbo].[FileSystemCelerraDelOnDelTask] DROP CONSTRAINT [PK_FileSystemCelerraDelOnDelTask]
ALTER TABLE [dbo].[JournalingTarget] DROP CONSTRAINT [PK_JournalingTarget]
ALTER TABLE [dbo].[MQUpgrade] DROP CONSTRAINT [PK_MQUpgrade]
ALTER TABLE [dbo].[MessageClassEntry] DROP CONSTRAINT [PK___13__10]
ALTER TABLE [dbo].[Monitoring] DROP CONSTRAINT [PK_Monitoring]
ALTER TABLE [dbo].[NetAppPlaceholderComputerEntry] DROP CONSTRAINT [PK_NetAppPlaceholderComputerEntry]
ALTER TABLE [dbo].[NotesDomainEntry] DROP CONSTRAINT [PK_NotesDomainEntry]
ALTER TABLE [dbo].[NotesJournalMailboxEntry] DROP CONSTRAINT [PK_NotesJournalMailboxEntry]
ALTER TABLE [dbo].[VaultStoreGroup] DROP CONSTRAINT [PK_VaultStoreGroup]
ALTER TABLE [dbo].[NotesJournalingTask] DROP CONSTRAINT [PK_NotesJournalingTask]
ALTER TABLE [dbo].[NotesMailServerEntry] DROP CONSTRAINT [PK_NotesMailServerEntry]
ALTER TABLE [dbo].[NotificationEntry] DROP CONSTRAINT [PK_Notification_NotificaitonId]
ALTER TABLE [dbo].[SISBoundary] DROP CONSTRAINT [PK_SISBoundary]
ALTER TABLE [dbo].[Organization] DROP CONSTRAINT [PK_Organization]
ALTER TABLE [dbo].[PSTPolicySettings] DROP CONSTRAINT [PK_PSTPolicySettings]
ALTER TABLE [dbo].[PartitionEntry] DROP CONSTRAINT [PK_PartitionEntry]
ALTER TABLE [dbo].[FingerprintCatalogueInstance] DROP CONSTRAINT [PK_FingerprintCatalogueInstance]
ALTER TABLE [dbo].[ExchangeMbxArchiveFolder] DROP CONSTRAINT [PK_RootArchiveFolderIdentity]
ALTER TABLE [dbo].[PhPolicySettingsEntry] DROP CONSTRAINT [PK_PhPolicySettingsEntry]
ALTER TABLE [dbo].[ReportSettings] DROP CONSTRAINT [PK_ ReportSettings]
ALTER TABLE [dbo].[PolicyEntry] DROP CONSTRAINT [PK_PolicyEntry]
ALTER TABLE [dbo].[FingerprintCatalogueDatabase] DROP CONSTRAINT [PK_FingerprintCatalogueDatabase]
ALTER TABLE [dbo].[DominoRetentionPlans] DROP CONSTRAINT [PK_SiteEntryId]
ALTER TABLE [dbo].[PstComputer] DROP CONSTRAINT [PK_PstComputer]
ALTER TABLE [dbo].[PstDomain] DROP CONSTRAINT [PK_PstDomain]
ALTER TABLE [dbo].[PstFile] DROP CONSTRAINT [PK_PstFile]
ALTER TABLE [dbo].[ArchiveHistory] DROP CONSTRAINT [PK_ArchiveHistoryIdentity]
ALTER TABLE [dbo].[PstLocatorTask] DROP CONSTRAINT [PK_PstLocatorTask]
ALTER TABLE [dbo].[PstMigrationHistory] DROP CONSTRAINT [PK_PstMigration]
ALTER TABLE [dbo].[ArchiveMoveHistory] DROP CONSTRAINT [PK_ArchiveMoveHistory]
ALTER TABLE [dbo].[PstMigratorTask] DROP CONSTRAINT [PK_PstMigratorTask]
ALTER TABLE [dbo].[PublicFolderTask] DROP CONSTRAINT [PK_PublicFolderTask]
ALTER TABLE [dbo].[VaultInterest] DROP CONSTRAINT [PK_VaultInterest]
ALTER TABLE [dbo].[QuoPolicySettingsEntry] DROP CONSTRAINT [PK_QuoPolicySettingsEntry]
ALTER TABLE [dbo].[FileServerRestoreFolders] DROP CONSTRAINT [PK_RESTOREID]
ALTER TABLE [dbo].[RcPolicySettingsEntry] DROP CONSTRAINT [PK_RcPolicySettingsEntry]
ALTER TABLE [dbo].[RetentionCategoryEntry] DROP CONSTRAINT [PK___12__10]
ALTER TABLE [dbo].[RetrievalTask] DROP CONSTRAINT [PK_RetrievalTask]
ALTER TABLE [dbo].[RegisteredClientMailboxes] DROP CONSTRAINT [PK_RegisteredClientMailboxes]
ALTER TABLE [dbo].[Root] DROP CONSTRAINT [PK_EVRoot]
ALTER TABLE [dbo].[RuPolicyRulesEntry] DROP CONSTRAINT [PK_RuPolicyRulesEntry]
ALTER TABLE [dbo].[FBActionMessages] DROP CONSTRAINT [PK_FBActionMessages]
ALTER TABLE [dbo].[SPSServiceEntry] DROP CONSTRAINT [PK_SPSServiceEntry]
ALTER TABLE [dbo].[FileServerNodeProps] DROP CONSTRAINT [PK_FileServerNodeProps]
ALTER TABLE [dbo].[SPSWorkspaceEntry] DROP CONSTRAINT [PK_SPSWorkspaceEntry]
ALTER TABLE [dbo].[ExchangeManagedContentSetting] DROP CONSTRAINT [PK_ExchangeManagedContentSetting]
ALTER TABLE [dbo].[SettingSection] DROP CONSTRAINT [PK_SettingSection]
ALTER TABLE [dbo].[SettingType] DROP CONSTRAINT [PK_SettingType]
ALTER TABLE [dbo].[SharePointPathTarget] DROP CONSTRAINT [PK_SharePointPathTarget]
ALTER TABLE [dbo].[TraceEntry] DROP CONSTRAINT [PK_TraceEntry]
ALTER TABLE [dbo].[SharePointPolicyEntry] DROP CONSTRAINT [PK_SharePointPolicyEntry]
ALTER TABLE [dbo].[SharePointServerEntry] DROP CONSTRAINT [PK_SharePointServerEntry]
ALTER TABLE [dbo].[SharePointTLSTarget] DROP CONSTRAINT [PK_SharePointTLSTarget]
ALTER TABLE [dbo].[SdPolicySettingsEntry] DROP CONSTRAINT [PK_SdPolicySettingsEntry]
ALTER TABLE [dbo].[SharePointTask] DROP CONSTRAINT [PK_SharePointTask]
ALTER TABLE [dbo].[EVDominoServer] DROP CONSTRAINT [PK_EVDominoServer]
ALTER TABLE [dbo].[SpPolicyRulesMetadataEntry] DROP CONSTRAINT [PK_SpPolicyRulesMetadataEntry]
ALTER TABLE [dbo].[ShoppingServiceEntry] DROP CONSTRAINT [PK___1__10]
ALTER TABLE [dbo].[SiteEntry] DROP CONSTRAINT [PK_SiteEntry_4__10]
ALTER TABLE [dbo].[SpPolicyRulesEntry] DROP CONSTRAINT [PK_SpPolicyRulesEntry]
ALTER TABLE [dbo].[SpPrPolicySettingsEntry] DROP CONSTRAINT [PK_SpPrPolicySettingsEntry]
ALTER TABLE [dbo].[StorageServiceEntry] DROP CONSTRAINT [PK___5__10]
ALTER TABLE [dbo].[NetappFileServerProxy] DROP CONSTRAINT [PK_NetappFileServerProxy]
ALTER TABLE [dbo].[Task] DROP CONSTRAINT [PK_Task]
ALTER TABLE [dbo].[TaskControllerServiceEntry] DROP CONSTRAINT [PK_TaskControllerServiceEntry]
ALTER TABLE [dbo].[Trustee] DROP CONSTRAINT [PK_Trustee]
ALTER TABLE [dbo].[UserData] DROP CONSTRAINT [PK_UserData]
ALTER TABLE [dbo].[DominoMailboxArchivingTask] DROP CONSTRAINT [PK_DominoMailboxArchivingTask]
ALTER TABLE [dbo].[VaultStoreEntry] DROP CONSTRAINT [PK___9__10]
ALTER TABLE [dbo].[FSAReportingWSLocations] DROP CONSTRAINT [PK_FSAReportingWSLocations]
ALTER TABLE [dbo].[FSAReportingConfiguration] DROP CONSTRAINT [PK_FSAReportingConfiguration_FSAReportingConfigurationId]
ALTER TABLE [dbo].[VolumePolicyEntry] DROP CONSTRAINT [PK_VolumePolicyEntry]
ALTER TABLE [dbo].[DominoMailboxPolicySyncTask] DROP CONSTRAINT [PK_DominoMailboxPolicySyncTask]
ALTER TABLE [dbo].[FSAReportingSite] DROP CONSTRAINT [PK_FSAReportingSite]
ALTER TABLE [dbo].[MonitoringHistory] DROP CONSTRAINT [PK_MonitoringHistory_1]
ALTER TABLE [dbo].[KeyStore] DROP CONSTRAINT [PK_KeyStore]
ALTER TABLE [dbo].[ExchangePolicySyncTask] DROP CONSTRAINT [PK_ExchangePolicySyncTask]
ALTER TABLE [dbo].[FSAReportingDatabase] DROP CONSTRAINT [PK_FSAReportingDatabaseId]
ALTER TABLE [dbo].[FSAReportingMappings] DROP CONSTRAINT [PK_FSAReportingMappings]
ALTER TABLE [dbo].[DominoMailboxEntry] DROP CONSTRAINT [PK_DominoMailboxEntryId]
ALTER TABLE [dbo].[FSAReportingProxyServers] DROP CONSTRAINT [PK_FSAReportingProxyServers]
ALTER TABLE [dbo].[CacheReplacmentSettings] DROP CONSTRAINT [PK_CacheRSFleServerEntry]
ALTER TABLE [dbo].[FSAReportingProxyServerMappings] DROP CONSTRAINT [PK_FSAReportingProxyServerMappings]
ALTER TABLE [dbo].[ldRuPolicyEntry] DROP CONSTRAINT [PK_ldRuPolicyEntryId]
ALTER TABLE [dbo].[ReportServerURLSettings] DROP CONSTRAINT [PK_ReportServerURLSettings]
ALTER TABLE [dbo].[ldScPolicySettingsEntry] DROP CONSTRAINT [PK_ldScPolicySettingsEntryId]
ALTER TABLE [dbo].[RetentionCategoryMappings] DROP CONSTRAINT [PK_RetentionCategoryMappings]
ALTER TABLE [dbo].[PolicyTargetGroup] DROP CONSTRAINT [PK_PolicyTargetGroup]
ALTER TABLE [dbo].[SubTask] DROP CONSTRAINT [PK_SubTask]
ALTER TABLE [dbo].[PolicyTargetMember] DROP CONSTRAINT [PK_PolicyTargetMember]
ALTER TABLE [dbo].[ExchangePolicyTargetGroup] DROP CONSTRAINT [PK_ExchangePolicyTargetGroup]
ALTER TABLE [dbo].[FileSpecification] DROP CONSTRAINT [PK_FileSpecification]
ALTER TABLE [dbo].[DominoPolicyTargetGroup] DROP CONSTRAINT [PK_DominoPolicyTargetGroup]
ALTER TABLE [dbo].[Locations] DROP CONSTRAINT [PK_LocationIdentity]
ALTER TABLE [dbo].[DominoTrustee] DROP CONSTRAINT [PK_ DominoTrustee]
ALTER TABLE [dbo].[DominoACE] DROP CONSTRAINT [PK_DominoACE]
ALTER TABLE [dbo].[ExchangeMailboxStore] DROP CONSTRAINT [PK_ExchangeMailboxStore]
ALTER TABLE [dbo].[FileBlockingAction] DROP CONSTRAINT [PK_FileBlockingAction]
ALTER TABLE [dbo].[FileBlockingRule] DROP CONSTRAINT [PK_FileBlockingRule]
ALTER TABLE [dbo].[ACE] DROP CONSTRAINT [PK_ACE]
ALTER TABLE [dbo].[MessageClassLink] DROP CONSTRAINT [PK_MessageClassLink]
ALTER TABLE [dbo].[AcceleratorEntry] DROP CONSTRAINT [PK_AcceleratorEntry]
ALTER TABLE [dbo].[AdminJobEntry] DROP CONSTRAINT [PK_AdminJobEntry]
ALTER TABLE [dbo].[FSAUtilityOperations] DROP CONSTRAINT [PK_FSAUtilityOperationsRowId]
ALTER TABLE [dbo].[AgentServiceEntry] DROP CONSTRAINT [PK_AgentServiceEntry]
ALTER TABLE [dbo].[Archive] DROP CONSTRAINT [PK_Archive]
-- DROP PK passed
-- ***
-- DROP COMPUTED COLUMNS
-- DROP COMPUTED COLUMNS passed.
-- ***
-- GET BAD TABLES INFO
-- GET BAD TABLE COLUMNS INFO
--
--Special section for copying table start time: Feb 15 2012 10:21AM
--
-- ***
-- COPY TABLES FOR COMPUTED COLUMNS
-- COPY TABLES FOR COMPUTED COLUMNS passed
-- GET CHAR COLUMNS INFO
--
--DROP section finish time: Feb 15 2012 10:21AM
--
--
--Change collation section start time: Feb 15 2012 10:21AM
--
-- ******************
-- TRY TO CHANGE COLLATION....
ALTER DATABASE EnterpriseVaultDirectory COLLATE SQL_Latin1_General_CP1_CI_AS
Msg 5075, Level 16, State 1, Line 1689
The object 'CK_RegisteredClientMailboxes_ClientOSType' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
Msg 5075, Level 16, State 1, Line 1689
The object 'CK_RegisteredClientMailboxes_MailboxServerType' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
Msg 5072, Level 16, State 1, Line 1689
ALTER DATABASE failed. The default collation of database 'EnterpriseVaultDirectory' cannot be set to SQL_Latin1_General_CP1_CI_AS.
-- ALTER DATABASE COLLATION FAILED, PLEASE CHECK THE REASON, ATTACH DB AND RUN AGAIN.
Msg 50000, Level 16, State 1, Line 1694
ALTER DATABASE COLLATION FAILED, PLEASE CHECK THE REASON, ATTACH DB AND RUN AGAIN.