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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 2000 sp4 link server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-09 : 09:38:22
Tram writes "After installing SP4 for SQL 2000 on one of my server, I noticed that the all the links are in upper case instead of mixed case. The collation for this server is not the default. It is SQL_Latin1_General_CP850_BIN (Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 40 on Code Page 850 for non-Unicode Data). Does SP4 automatically make all link server upper case or does it base that on the collation of the server.

Any help will be greatly appreciated.

Thanks"
   

- Advertisement -