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 |
|
TechNess
Starting Member
11 Posts |
 Posted - 2010-08-27 : 01:32:45
|
| Hi everyone,I was able to download Adventureworks database but I think the default setting was Case Sensitive. I went to the properties of Adventureworks and changed the collation to Latin1_General_CI_AS it gave me following error: TITLE: Microsoft SQL Server Management Studio Express------------------------------Alter failed for Database 'AdventureWorks'. (Microsoft.SqlServer.Express.Smo)ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------The database could not be exclusively locked to perform the operation.ALTER DATABASE failed. The default collation of database 'AdventureWorks' cannot be set to Latin1_General_CI_AS. (Microsoft SQL Server, Error: 5030)Can anyone help on this?**TechNess** |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-27 : 05:49:53
|
No users should be connected to that database.And you have to disconnect/close all query windows to that database.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-27 : 08:37:35
|
| [code]ALTER DATABASE Adventureworks SET SINGLE_USER WITH rollback immediate;goALTER DATABASE Adventureworks COLLATE SQL_Latin1_General_CP1_CI_AS;GOALTER DATABASE Adventureworks SET MULTI_USER;GO[/code] |
|
|
|
|
|
|
Changing from Case Sensitive to Case Insensitive?