March 13, 2003 at 6:22 am
The other week I rebuilt my system dbs to change the collation order, all seemed well however today after restarting the server my msdb I notice I keep getting the message:
[298] SQLServer Error: 446, Cannot resolve collation conflict for equal to operation. [SQLSTATE 42000], and I see that the collation is different to the rest. How can this be! It was rebuilt and all the other system dbs have changed OK. Is there a way I can just change the msdb collation? Do they all have to be rebuilt again? ALTER database colation does not work with the system database. Thanks for any help you can give. The annoying things was the the serverproperty ('collation') was not a valid test as it seem to only return the server collation not that for all the diff dbs, but this was the test I initially ran to see if it had been corrected.
Can you restore another msdb from another server to overright the collation order?
Rob
March 13, 2003 at 7:34 am
Use following commands to verify the database collation and sort order.
select DatabasePropertyEx('msdb','Collation')
go
select DatabasePropertyEx('msdb','SQLSortOrder')
go
And use trace flag T3608 for your MSDB restoration or re-attachment.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
March 13, 2003 at 7:46 am
Thanks for the query. I don't understand how you use the trace flag mind. I have discovered that I can restore another msdb over the current one to get the right collation order, it's just a pain, as then I have to script all the jobs and logins back in.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply