We are currently running CCM 4.1(2) and IPCC 6.0. Both use SQL Server 2000 SP3.
We have a link to the HDS servers from another SQL Server which pulls things like the Termination Call Detail records every night. We are going to be upgrading that server to SQL Server 2005 x64-bit edition. There is a known problem which has been identified in the Microsoft KB found here:
We have this issue currently which according to the KB, means the stored procedures were not upgraded properly. The "fix" is to manually upgrade the stored procedures with the instcat.sql script.
I see no reason that this should really affect anything in our ICM environment. I contacted our support team who instructed me that there is no support for this script.
On the other hand, this seems very benign to me. My question is has anyone done this? Does anyone know of anything I should consider before running this script?