Good Morning experts,
We have 2 sql servers each with multiple databases, one server is 2008 and the other server is 2005. the databases on the 2008 server have a different collation than the ones on the 2005 server.
I did the following for the databases on the 2008 server
ALTER DATABASE [finance] COLLATE SQL_Latin1_General_Pref_CP1_CI_AS
It changed the database and the table collations, however the column collation remained
unchanged. I know I can go in and changed the column collation one by one but that is not a feasible solution.
is there a way I can change the collation for all the columns at once?