Collation problem

[topci]

Hi,

i have realy silly problem. I create database in MS Sql server with wrong collation. I have to many tables in database; all tables are created with wrong collation. Have somebody idea how to change collation in all tables, not to manual changing fields in all tables?

Please, help me, my customer is .... (you known, how are the Customers...)

Tnx, DaT

 

[mrdenny]

If you didn't specify the collation type if should be taking the default. You should be able to use the alter database command to change the collation type of the database.

Worse comes to worse you can script the objects and recreate them that way.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[topci]

Thanks,
if it's this only Solution, i will make this for all tables. I was expected, there will be easy way to solve this...

Lp,DaT

 

[Catadmin]

If you are consistantly created DBs with the wrong collation, your SQL Server may have been incorrectly installed. Are you needing to change the collation on ALL your databases, or specific user DBs?

I would take a look at backing up your data, then uninstalling and reinstalling (with the *correct* collation) your SQL Server if you have to change every single last DB to a different, but the same for all, collation than what they are currently set at.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???