Sunday, March 25, 2012

Collation issue

Dear all,
I''ve got a database which own sql1_latin1_General_cp1_ci_as. That's fine.
I'd like to change the current collation for 'Traditional_Spanish_CI_AS'
using the following statements:
1-ALTER DATABASE bdtestman SET SINGLE_USER with rollback immediate
2-ALTER DATABASE bdtestman COLLATE Traditional_Spanish_CI_AS
3-ALTER DATABASE bdtestman Set MULTI_USER
2 failed and said me:
Server: Msg 5075, Level 16, State 1, Line 1
The column 'F211_Maastrich_OverallTestsResultsNoSha
ll.NOMPROYECTO' is
dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 1
The column 'F211_Maastrich_OverallTestsResultsNoSha
ll.NOMNIVEL' is dependent
on database collation.
Server: Msg 5075, Level 16, State 1, Line 1
The column 'F211_Maastrich_OverallTestsResultsNoSha
ll.NOMELEMENTO' is
dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 1
The column 'F211_Maastrich_OverallTestsResultsNoSha
ll.NOMPRUEBA' is
dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 1
The column 'F211_Maastrich_OverallTestsResultsNoSha
ll.NOMCASO' is dependent
on database collation.
Does anyone ever used this statement in order to change the current collatio
n?
Thanks for any input and regards,If F211_Maastrich_OverallTestsResultsNoShal
l is a view, drop it before you
try changing the database collation, then recreate it after the change is
made.
ML
http://milambda.blogspot.com/|||according to books online
You are the only one currently using the database.
No schema bound object is dependent on the collation of the database.
If the following objects, which are dependent on the database
collation, exist in the database, the ALTER DATABASE database COLLATE
statement will fail. SQL Server will return an error message for each
object blocking the ALTER action:
User-defined functions and views created with SCHEMABINDING.
Computed columns.
CHECK constraints.
Table-valued functions that return tables with character columns with
collations inherited from the default database collation.
Look at alter database in books onlne.
Regardssqlsql

No comments:

Post a Comment