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.
| Author |
Topic |
|
jemal37
Starting Member
1 Post |
 Posted - 2008-11-06 : 04:03:20
|
| My database is collation Latin1_General_CP1_AS. im trying change incollation design or code taking error:The db could not be exclusively locked to perform the operation cannot be set to Latin1_General_CP1_AL or Turkish_bin.This db all the table has data...trying enter data sinanay--sinanay automatic convert.What you suggest me? thanks. |
|
|
brianjensen
Starting Member
22 Posts |
Posted - 2008-11-07 : 08:29:08
|
| You have to make sure that the database is not in use when changing the collation. Setting it in restricted_user mode may help.If your database contains data, you may have to change the collation of all columns too. Collations are generally not the best thing to mess with, that's why you should always get it right from the start :) |
 |
|
|
|
|
|
Collation change DB