Can you please let me know how to change the collation of the sever as I missed to change the default collation at the time of istallation.?
Thanks in Advance.
asked Mar 31 '11 at 05:35 AM in Default
For me I'd use something like RedGate SQL Compare and SQL DataCompare to do the scripting and data move. You would need a new server (possibly only temporary) configured how you want it and ship all data over to that.
answered Mar 31 '11 at 08:14 AM