We had a wrong database colletion in our MS SQL Server. Trying to change the collation caused problem like "The database could not be exclusively locked to perform the operation". Here is how we solved it.
alter database db_name set single_user
alter database db_name collate SQL_LATIN_GENERAL1_CI_AS
alter database db_name set multi_user
Over!
Monday, June 23, 2008
Subscribe to:
Posts (Atom)