SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Notifications]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Notifications] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Notifications_{objectQualifier}DMX_Log]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Extensions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Extensions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Extensions_{objectQualifier}DMX_Addons]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_EntriesML]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntriesML] DROP
CONSTRAINT [FK_{objectQualifier}DMX_EntriesML_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Log]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Log] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Log_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Repository]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Repository] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Repository_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Attributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Attributes] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Attributes_{objectQualifier}DMX_Addons],
CONSTRAINT [FK_{objectQualifier}DMX_Attributes_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryPermissions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_EntryPermissions_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_CategoriesML]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_CategoriesML] DROP
CONSTRAINT [FK_{objectQualifier}DMX_CategoriesML_{objectQualifier}DMX_Categories]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Subscriptions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Subscriptions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Subscriptions_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_AttributeEntrytypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_AttributeEntrytypes] DROP
CONSTRAINT [FK_{objectQualifier}DMX_AttributeEntrytypes_{objectQualifier}DMX_Attributes]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Categories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Categories] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Categories_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_EntryCategories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryCategories] DROP
CONSTRAINT [FK_{objectQualifier}DMX_EntryCategories_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes] DROP
CONSTRAINT [FK_{objectQualifier}DMX_PermissionEntrytypes_{objectQualifier}DMX_Permissions]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_EntryAttributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryAttributes] DROP
CONSTRAINT [FK_{objectQualifier}DMX_EntryAttributes_{objectQualifier}DMX_Attributes],
CONSTRAINT [FK_{objectQualifier}DMX_EntryAttributes_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_ApplicationPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_ApplicationPermissions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_ApplicationPermissions_Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_DirectAccessKeys]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_DirectAccessKeys] DROP
CONSTRAINT [FK_{objectQualifier}DMX_DirectAccessKeys_Entries]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_AttributesML]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_AttributesML] DROP
CONSTRAINT [FK_{objectQualifier}DMX_AttributesML_{objectQualifier}DMX_Attributes]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Entries] DROP
CONSTRAINT [FK_{objectQualifier}DMX_Entries_{objectQualifier}Portals]
GO
PRINT N'Dropping foreign keys from {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionPermissions] DROP
CONSTRAINT [FK_{objectQualifier}DMX_PermissionPermissions_{objectQualifier}DMX_Permissions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Addons]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Addons] DROP CONSTRAINT [PK_{objectQualifier}DMX_Addons]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Settings]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Settings] DROP CONSTRAINT [PK_{objectQualifier}DMX_Settings]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Notifications]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Notifications] DROP CONSTRAINT [PK_{objectQualifier}DMX_Notifications]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Extensions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Extensions] DROP CONSTRAINT [PK_{objectQualifier}DMX_Extensions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_EntriesML]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntriesML] DROP CONSTRAINT [PK_{objectQualifier}DMX_EntriesML]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_LogTypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_LogTypes] DROP CONSTRAINT [PK_{objectQualifier}DMX_LogTypes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_SearchResults]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_SearchResults] DROP CONSTRAINT [DF__{objectQualifier}DM__Hits__2DBCB4E6]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Log]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Log] DROP CONSTRAINT [PK_{objectQualifier}DMX_Log]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Repository]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Repository] DROP CONSTRAINT [PK_{objectQualifier}DMX_Repository]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMXDAV_Numbers]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMXDAV_Numbers] DROP CONSTRAINT [Index_Numbers]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Attributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Attributes] DROP CONSTRAINT [PK_{objectQualifier}DMX_Attributes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Attributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Attributes] DROP CONSTRAINT [DF__{objectQualifier}D__Colle__155B1B70]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Subscriptions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Subscriptions] DROP CONSTRAINT [PK_{objectQualifier}DMX_Subscriptions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryPermissions] DROP CONSTRAINT [PK_{objectQualifier}DMX_EntryPermissions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_CategoriesML]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_CategoriesML] DROP CONSTRAINT [PK_{objectQualifier}DMX_CategoriesML]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_AttributeEntrytypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_AttributeEntrytypes] DROP CONSTRAINT [PK_{objectQualifier}DMX_AttributeEntrytypes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Categories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Categories] DROP CONSTRAINT [PK_{objectQualifier}DMX_Categories]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_EntryCategories]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryCategories] DROP CONSTRAINT [PK_{objectQualifier}DMX_EntryCategories]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes] DROP CONSTRAINT [PK_{objectQualifier}DMX_PermissionEntrytypes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_EntryAttributes]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_EntryAttributes] DROP CONSTRAINT [PK_{objectQualifier}DMX_EntryAttributes]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_ApplicationPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_ApplicationPermissions] DROP CONSTRAINT [PK_{objectQualifier}DMX_ApplicationPermissions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_DirectAccessKeys]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_DirectAccessKeys] DROP CONSTRAINT [PK_{objectQualifier}DMX_DirectAccessKeys]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_AttributesML]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_AttributesML] DROP CONSTRAINT [PK_{objectQualifier}DMX_AttributesML]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Providers]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Providers] DROP CONSTRAINT [PK_{objectQualifier}DMX_Providers]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Permissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Permissions] DROP CONSTRAINT [PK_{objectQualifier}DMX_Permissions]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Entries] DROP CONSTRAINT [PK_{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_Entries] DROP CONSTRAINT [DF__{objectQualifier}D__Inher__0ADD8CFD]
GO
PRINT N'Dropping constraints from {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]'
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DMX_PermissionPermissions] DROP CONSTRAINT [PK_{objectQualifier}DMX_PermissionPermissions]
GO
PRINT N'Dropping index [IX_{objectQualifier}DMX_Entries_Data1] from {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
DROP INDEX [IX_{objectQualifier}DMX_Entries_Data1] ON {databaseOwner}[{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping index [IX_{objectQualifier}DMX_Entries_CollectionID] from {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
DROP INDEX [IX_{objectQualifier}DMX_Entries_CollectionID] ON {databaseOwner}[{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping index [{objectQualifier}IX_DMX_EntryAttributes_EntryId] from {databaseOwner}[{objectQualifier}DMX_EntryAttributes]'
GO
DROP INDEX [{objectQualifier}IX_DMX_EntryAttributes_EntryId] ON {databaseOwner}[{objectQualifier}DMX_EntryAttributes]
GO
PRINT N'Dropping index [{objectQualifier}IX_DMX_EntryCategories_EntryId] from {databaseOwner}[{objectQualifier}DMX_EntryCategories]'
GO
DROP INDEX [{objectQualifier}IX_DMX_EntryCategories_EntryId] ON {databaseOwner}[{objectQualifier}DMX_EntryCategories]
GO
PRINT N'Dropping index [{objectQualifier}IX_DMX_EntryPermissions_PermissionId] from {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
DROP INDEX [{objectQualifier}IX_DMX_EntryPermissions_PermissionId] ON {databaseOwner}[{objectQualifier}DMX_EntryPermissions]
GO
PRINT N'Dropping index [{objectQualifier}IX_DMX_EntryPermissions_RoleId] from {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
DROP INDEX [{objectQualifier}IX_DMX_EntryPermissions_RoleId] ON {databaseOwner}[{objectQualifier}DMX_EntryPermissions]
GO
PRINT N'Dropping index [{objectQualifier}IX_DMX_Log_EntId] from {databaseOwner}[{objectQualifier}DMX_Log]'
GO
DROP INDEX [{objectQualifier}IX_DMX_Log_EntId] ON {databaseOwner}[{objectQualifier}DMX_Log]
GO
PRINT N'Dropping index [{objectQualifier}IX_DMX_PermissionPermissions_RoleId] from {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]'
GO
DROP INDEX [{objectQualifier}IX_DMX_PermissionPermissions_RoleId] ON {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DatabaseUsage]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DatabaseUsage]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetDirectAccessKeysByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetDirectAccessKeysByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ReparseDMXFileTypes]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_ReparseDMXFileTypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_RemoveOldUserSubscriptions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_RemoveOldUserSubscriptions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetApplicationPermissionsForUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetApplicationPermissionsForUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SearchResultsClean]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SearchResultsClean]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetApplicationPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetApplicationPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryListAsXml]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryListAsXml]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttributeListForEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttributeListForEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributeListForEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributeListForEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUserPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUserPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryBranch]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryBranch]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddFolder]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddFolder]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_ApplicationPermissions]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_ApplicationPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryPermissionsForUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryPermissionsForUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributesByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributesByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SoftDeleteEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SoftDeleteEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntriesByFilenameInCollection]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntriesByFilenameInCollection]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryIsIn]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_EntryIsIn]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateFileSize]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateFileSize]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetHostSetting]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetHostSetting]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryPermissionsByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryPermissionsByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetApprovedEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetApprovedEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ToggleDelete]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_ToggleDelete]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetLastVersionID]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetLastVersionID]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUsersToNotify]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUsersToNotify]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_LockEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_LockEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributesByAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributesByAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogByTime]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogByTime]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionsForEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionsForEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetLastModified]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetLastModified]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByKeyAndValue]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByKeyAndValue]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryByLockKey]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryByLockKey]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateHostSetting]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateHostSetting]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ExtractConcatenate]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMX_ExtractConcatenate]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogsByUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogsByUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogsByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogsByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UnLockEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UnLockEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_IsEntryPermissionByAdmin]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_IsEntryPermissionByAdmin]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntriesByUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntriesByUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetEntryThumbnail]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetEntryThumbnail]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUserRoles]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUserRoles]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetModuleUsageList]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetModuleUsageList]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionsByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionsByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_GetPath]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMXDAV_GetPath]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_MoveAllEntries]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_MoveAllEntries]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCollectionContents]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCollectionContents]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_MoveEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_MoveEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryByFilename]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryByFilename]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributesByEntryType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributesByEntryType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntriesByPortalAndProvider]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntriesByPortalAndProvider]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_FindAttributeByKey]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_FindAttributeByKey]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttributeByEntryAndKey]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttributeByEntryAndKey]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryPermissionMaintenance]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_EntryPermissionMaintenance]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_FindEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_FindEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddHostSetting]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddHostSetting]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributes]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UnifyRemovePermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UnifyRemovePermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_MoveAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_MoveAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_EntriesLocalized]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_EntriesLocalized]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_IsSuperUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_IsSuperUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_RenameEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_RenameEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPortalAttributeListWithEntryData]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPortalAttributeListWithEntryData]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_EntryPermissions]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_EntryPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DMXInfo]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DMXInfo]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntriesByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntriesByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_Entries]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_Entries]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsForEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsForEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUsersByRoleId]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUsersByRoleId]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPortalDetails]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPortalDetails]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UnifySetPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UnifySetPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_PermissionPermissions]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_PermissionPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryByTitleInCollection]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryByTitleInCollection]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSpecificEntryPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSpecificEntryPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_RemoveOldUserNotifications]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_RemoveOldUserNotifications]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryByTitle]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryByTitle]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUserRolesByRoleId]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUserRolesByRoleId]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_RemoveDeadPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_RemoveDeadPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetParentChain]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetParentChain]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_MoveEntryAttributes]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_MoveEntryAttributes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategoryByName]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategoryByName]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetBreadCrumbs]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetBreadCrumbs]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryBranch]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryBranch]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdatePaths]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdatePaths]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategories]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategories]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAllPortalCollections]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAllPortalCollections]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UnifyPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UnifyPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_LimitSearch]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_LimitSearch]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SearchResults]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_SearchResults]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_ActiveUserRoles]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_ActiveUserRoles]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryAttributesByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategoriesByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategoriesByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Attributes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Attributes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DBCleanup]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DBCleanup]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogsByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogsByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_Log]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_Log]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetUnsentNotifications]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetUnsentNotifications]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}vw_DMX_Notifications]'
GO
DROP VIEW {databaseOwner}[{objectQualifier}vw_DMX_Notifications]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryTitle]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryTitle]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ResetPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_ResetPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ResetFolderSizes]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_ResetFolderSizes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Entries]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Entries]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryLocalizations]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryLocalizations]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttributesByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttributesByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionByKey]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionByKey]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetEntryCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetEntryCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateProvider]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateProvider]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategoryLocalizations]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategoryLocalizations]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeletePermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeletePermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddAttributeEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddAttributeEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetProvider]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetProvider]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddProvider]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddProvider]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEventLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEventLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytypesByPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytypesByPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetExtensionsByAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetExtensionsByAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddPermissionEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddPermissionEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributeLocalizations]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributeLocalizations]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetSetting]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetSetting]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetPermissionPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetPermissionPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributeEntrytypesByAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributeEntrytypesByAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubCategories]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubCategories]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSetting]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSetting]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteSettings]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteSettings]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByEntry]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetEntryCategoriesByEntry]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntryPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntryPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetCategoryLocalization]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetCategoryLocalization]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAddonsWithFeature]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAddonsWithFeature]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteAttributeEntrytypes]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteAttributeEntrytypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_URLEncode]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMXDAV_URLEncode]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_Numbers]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMXDAV_Numbers]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddDirectAccessKey]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddDirectAccessKey]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_NumberOfCategories]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_NumberOfCategories]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateEntryAttribute]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateEntryAttribute]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteEntryCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteEntryCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_MoveLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_MoveLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteFromRepository]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteFromRepository]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetExtension]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ClearEntryPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_ClearEntryPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_FindAddonByName]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_FindAddonByName]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteProvider]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteProvider]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetExtensionsByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetExtensionsByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddToRepository]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddToRepository]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetCategoriesByPortal]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetCategoriesByPortal]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeletePermissionEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeletePermissionEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetApplicationPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetApplicationPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteLog]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteLog]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteSetting]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteSetting]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMXDAV_GetExtension]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMXDAV_GetExtension]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetAttributeEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetAttributeEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteApplicationPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteApplicationPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLastActionEvent]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLastActionEvent]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteDirectAccessKey]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteDirectAccessKey]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ApplicationPermissions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_ApplicationPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdatePermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdatePermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSettings]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSettings]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Settings]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Settings]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeleteAttributeEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeleteAttributeEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetAttributeLocalization]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetAttributeLocalization]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateNotification]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateNotification]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DirectAccess]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DirectAccess]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_CleanUpDirectAccessKeys]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_CleanUpDirectAccessKeys]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DirectAccessKeys]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_DirectAccessKeys]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetFromRepository]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetFromRepository]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Repository]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Repository]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_ListProviders]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_ListProviders]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Categories]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Categories]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermission]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermission]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddAddon]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddAddon]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryAttributes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_EntryAttributes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_SetEntryLocalization]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_SetEntryLocalization]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Split]'
GO
DROP FUNCTION {databaseOwner}[{objectQualifier}DMX_Split]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetProvidersByType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetProvidersByType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Providers]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Providers]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Notifications]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Notifications]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Log]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Log]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytype]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetPermissionEntrytype]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_PermissionEntrytypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogTypes]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogTypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntriesML]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_EntriesML]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UpdateSubscription]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UpdateSubscription]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AddEntryCategory]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_AddEntryCategory]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryCategories]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_EntryCategories]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_CategoriesML]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_CategoriesML]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Addons]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Addons]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AttributeEntrytypes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_AttributeEntrytypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Extensions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Extensions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetLogType]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetLogType]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_LogTypes]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_LogTypes]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_EntryPermissions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_EntryPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByUser]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_GetSubscriptionsByUser]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_DeletePermissionPermissions]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_DeletePermissionPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_PermissionPermissions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_UserAccess]'
GO
DROP PROCEDURE {databaseOwner}[{objectQualifier}DMX_UserAccess]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Subscriptions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Subscriptions]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_AttributesML]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_AttributesML]
GO
PRINT N'Dropping {databaseOwner}[{objectQualifier}DMX_Permissions]'
GO
DROP TABLE {databaseOwner}[{objectQualifier}DMX_Permissions]
GO
