Script för att ändra schema i SQL databas.

/* Genreate schema update script for tables with specific schema name */

USE TestDB

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.tables

WHERE SCHEMA_NAME(schema_id) = @schemaName

/* Genreate schema update script for sp with specific schema name */

USE TestDB

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.procedures

WHERE SCHEMA_NAME(schema_id) = @schemaName

/* Genreate schema update script for view with specific schema name */

USE TestDV

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.views

WHERE SCHEMA_NAME(schema_id) = @schemaName

Problem med Enterprise Vault filesystem arkivering

File System Archiving automatically configures the Internet Explorer settings so that the Web Access application computer is in the Internet Explorer trusted siteslist. File System Archiving checks this setting each time the file server is processed on an archiving run.

If the computer that runs the Placeholder service has incorrect Internet Explorer security settings, users cannot open any placeholder shortcuts. Each attempt todo so produces an entry on the Windows Application log on the placeholdercomputer, saying that there was an error downloading a file.

To configure the Internet Explorer security settings

  1. Log on as the Vault Service account to the computer that is running thePlaceholder service.
  2. On the Windows Start menu, click Settings > Control Panel.
  3. Double-click Internet Options.
  4. Click the Security tab.
  5. In the list of zones, click Local intranet.
  6. Click Sites.
  7. Click Advanced.
  8. Enter the name of the Web Access application computer, without the DNSdomain, and then click Add.
  9. Click OK.
  10. Click OK to close the local intranet settings.
  11. On the Security tab of the Internet Options dialog box, click Custom Level.12 Under User Authentication in the Security Settings dialog box, select eitherAutomatic logon only in Intranet zone or Automatic logon with current username and password.
  12. Click OK to close the Security Settings dialog box.
  13. Click OK to close the Internet Options dialog box.

Från Enterprise Vault Adminguide…