Collation Error

When I change db collation sql says
"You cannot change database collation"
"The object XXXX is dependent on database collation.". Is there any way to
change database collation? (without creating new database from script)
thank you
Hi
Have you tried changing the column colations before changing the database
collation?
John
"Cenk FIRAT" wrote:

> When I change db collation sql says
> "You cannot change database collation"
> "The object XXXX is dependent on database collation.". Is there any way to
> change database collation? (without creating new database from script)
> thank you
|||All columns collation is <database default> and our database file is
orginally sql 2000 file but use in sql 2005. because of that our database
collations is seems "Compatibility_129_41f_0"..
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you tried changing the column colations before changing the database
> collation?
> John
> "Cenk FIRAT" wrote:
|||Hi
If these are not columns that are causing the issue then you should be able
to script them, drop them, change the database collation and then re-create
them.
John
"Cenk FIRAT" wrote:
[vbcol=seagreen]
> All columns collation is <database default> and our database file is
> orginally sql 2000 file but use in sql 2005. because of that our database
> collations is seems "Compatibility_129_41f_0"..
> "John Bell" wrote: