EV9 SQL2005 changing collation

[GertjanA]

Hello all,

Customer is trying to change the collation, using the scipt provided by MS. (link follows shortly)

Script fails somewhere with below error:

ALTER TABLE [dbo].[ReportSettings] DROP CONSTRAINT [PK_ ReportSettings]
ALTER TABLE [dbo].[RetentionCategoryEntry] DROP CONSTRAINT [PK___12__10]
ALTER TABLE [dbo].[RetentionPolicy] DROP CONSTRAINT [PK_RetentionPolicy]
ALTER TABLE [dbo].[RetentionPolicyRuleMapping] DROP CONSTRAINT [PK_RetentionPolicyRuleMapping]
ALTER TABLE [dbo].[udf_TypeBitmaskConverter] DROP CONSTRAINT [PK__udf_TypeBitmaskC__550B8C31]
Msg 4909, Level 16, State 1, Line 1
Cannot alter 'dbo.udf_TypeBitmaskConverter' because it is not a table.
--DROP PK FAILED. SEE ERROR LOG FOR DETAILS.
Msg 50000, Level 16, State 1, Line 1378
DROP PK FAILED. SEE ERROR LOG FOR DETAILS.

Does anyone know how to fix?

This is on the Directory database. EV9.0SP2

[MarkBarefoot]

yeh, that is in the preceeding sentence :) - just wanted to show you the table

[shampoo]

When I run the complete VaultStoreDB_8_Programmability.sql script in step 12 as described in TECH55063 can I ignore these errors without worries?

-Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'uspci_AggregateReports'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.

-Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'uspu_ConsolidateHistoricalData'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. 
 

The collation has changed, everything is operational and the deployment scanner gives no errors.

I have these databases:

EnterpriseVaultDirectory
EnterpriseVaultMonitoring
EVVSExpressVaultStore_1
EVVSGExpressVaultStoreGroup_1_1

- GertjanA mentioned it might be related to EV-REPORTING (which we don't have)
- Symantec Support said re-install the binaries to restore the tables. (which I ignored)