Setting Database Default Collation
Re-invent ASP.NET Hosting Community
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Setting Database Default Collation Expand / Collapse
Author
Message
Posted 11/16/2006 3:55:00 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 12/2/2006 7:21:00 AM
Posts: 10, Visits: 1

How can I cross this problem?

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Alter failed for Database 'AbxaziaInfo'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------
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 'AbxaziaInfo' cannot be set to Latin1_General_BIN. (Microsoft SQL Server, Error: 5030)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=5030&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------



Nika Mamulashvili
AbxaziaInfo

Post #420
Posted 11/16/2006 4:28:00 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Administrators
Last Login: Yesterday @ 10:51:33 PM
Posts: 161, Visits: 397
Please contact Re-invent Support for them to change the Collation of your database.

Paul B

Re-invent Technologies LLC
http://www.re-invent.com

Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!

Post #421
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Administrator, Re-invent (Paul), Re-invent (Nick)

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 4:55am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 10 queries. Compression Disabled.


Copyright 2007 Re-invent Technologies LLC All Rights Reserved.