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)
 chanage collation

Author  Topic 

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-10 : 05:15:50
Hi

when i tried to cahange the collation name of the database it is giving error.

database name= ODD.4mak
I used this query but Iam getting error

ALTER DATABASE ODD.4mak COLLATE SQL_Latin1_General_CP1_CI_AS

if use same query for database name 'markprod' query is competed successfully

please suggest me

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-10 : 05:18:34
What error you are getting?
Try putting square brackets around DB name.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-10 : 05:20:06
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36707
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46915


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-10 : 05:24:57
if i put sqare brackets query is running successfully

thank you for suggestion
Go to Top of Page
   

- Advertisement -