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)
 setting collation property in the uploaded site

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-12-12 : 08:54:24
rath writes "we are using the feature of collation property of sqlserver 2000
but the problem arises when we uploaded the table structure through generated script since the in space sqlserver does not support collation property.so how to tackle this"

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2002-12-16 : 02:25:29
quote:

rath writes "we are using the feature of collation property of sqlserver 2000
but the problem arises when we uploaded the table structure through generated script since the in space sqlserver does not support collation property.so how to tackle this"



Collation settings, which include character set, sort order, and other locale-specific settings, are fundamental to the structure of all SQL 2000 databases. To change one or more of these settings, you must rebuild the master and user databases.
there is lot of help available on this in bol ,search for: collations, changing settings

Harshal.





Edited by - harshal_in on 12/16/2002 02:27:37
Go to Top of Page
   

- Advertisement -