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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2007-11-21 : 05:20:18
|
| Hi Guys I am trying to create a Linked server on Sql Server 2000 with Collation Latin1_General_CI_AS with an Sql 2005 Server having collation SQL_Latin1_General_CP1_CI_ASWhen i created the Linked server using the MSDASQL Provider and try to expand the Linked server node It throws the following error Cannot Resolve collation Conflict for equal to OperationHow do i resolve this problem?Vic |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-21 : 16:33:48
|
| Tried create it in gui? There are collation options in server options tab. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-22 : 05:25:37
|
| Alternitively, use sp_serveroption to set the collation. |
|
|
|
|
|
|
Linked Server : With Collation