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 2005 Forums
 SQL Server Administration (2005)
 Collation

Author  Topic 

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2009-10-13 : 00:22:35
Can anyone let me know on SQL Server 2000 Server what should be the collation name?

Like whether I should have Ex: Latin1_General_CI_AS?

Thanks All.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-13 : 01:21:32
It depends on your data requirements.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2009-10-13 : 18:49:24
I have changed on 2005 server: from Latin1_General_CP1_CI_AS to SQL_Latin1_General_CP1_CI_AS, but it didn't got through as and when the original Database with Latin1_General_CP1_CI_AS has again replaced the SQL_Latin1_General_CP1_CI_AS

Any Help please
Go to Top of Page

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2009-10-13 : 18:53:29
Further there was an error with 5075 which states The Object "RNTOU" is dependant on collation name ( Collation name is Latin1_General_CP1_CI_AS which is orginal and I tried to changed it to SQL_Latin1_General_CP1_CI_AS )

Please any help.
Many Thanks
Go to Top of Page

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2009-10-15 : 18:23:45
Can anyone please let me know for this imbroglio.

it says" database object "RNN05_OT" is supported by SQL_Latin1_General_CP1_AS.

Previously it is on Latin1_General_CP1_AS.

Not much help on the doc's. Please someone intervene here and help me.

Thanks in advance.
Go to Top of Page
   

- Advertisement -