InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 11:16:09 GMT20http://www.sqlservercentral.com/Forums/Topic443054-5-1.aspxFirst post, caught it after I sent it thanks for the feedbackTue, 15 Jan 2008 09:07:57 GMTRRIOS42http://www.sqlservercentral.com/Forums/Topic443054-5-1.aspx[quote][b]Ray (1/15/2008)[/b][hr]Did you use RedGate tools? If so i have them as well.[/quote]Ray - take a little closer look at Andras' signature....:DI'd say it's a fair bet that he has RedGate Tools.....:cool:Tue, 15 Jan 2008 09:03:59 GMTMatt Miller (#4)http://www.sqlservercentral.com/Forums/Topic443054-5-1.aspx[quote][b]Ray (1/15/2008)[/b][hr]Did you use RedGate tools? If so i have them as well.[/quote]Yep :) (in this case, to script a db you can just compare it against an empty database, and save the synchronization script :)AndrasTue, 15 Jan 2008 08:59:37 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic443054-5-1.aspxDid you use RedGate tools? If so i have them as well.Tue, 15 Jan 2008 08:41:57 GMTRRIOS42http://www.sqlservercentral.com/Forums/Topic443054-5-1.aspxAn alternative could be is to use a third party tool to script the whole schema, modify the creation script to include the right collation, create the new database, use tool to migrate all the data. There may be a better approach, but this is what I used :)AndrasTue, 15 Jan 2008 08:39:03 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic443054-5-1.aspxHave read most of the postings with regards to this but can seem to get it, currently unable to change DB collation because of the following error: Server: Msg 5075, Level 16, State 1, Line 1The object ' ' is dependent on database collation. I have lots of objects, triggers, FK, PK, etc...Not only do I need for the DB to change going forward but the data that is there as well.Goal would be to:Disable all objects change db collationchange table collationIs it possible?Tue, 15 Jan 2008 08:34:06 GMTRRIOS42