USE BD_ILC_FORMS
EXEC sp_changedbowner sa
USE BD_ILC_OBJECTS
EXEC sp_changedbowner sa
USE BD_SITE1_APP
EXEC sp_changedbowner sa
USE BD_SITE2_APP
EXEC sp_changedbowner sa
USE master
ALTER DATABASE BD_SITE1_APP SET trustworthy ON
ALTER DATABASE BD_SITE2_APP SET trustworthy ON
-- toggle permission set so that can run License section...
USE BD_SITE1_APP
ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS
USE BD_SITE2_APP
ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS
Comments