Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Shamee_1321
Starting Member
15 Posts |
Posted - 2008-02-15 : 06:29:58
|
How can I change the collation of a db from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS???? Is this possibleI am trying to map tables from 2 db... I am having error becoz of the collation.. |
|
Shamee_1321
Starting Member
15 Posts |
Posted - 2008-02-15 : 06:32:16
|
sorry , i have posted in a wrong forum... actually i am using sql server 2005.. |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-15 : 07:50:30
|
you can use COLLATE clause to prevent the error in expressions[url]http://www.databasejournal.com/features/mssql/article.php/3302341http://technet.microsoft.com/en-us/library/ms179886.aspx[/url] |
 |
|
|
|
|