Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Change collation of databes?
Message
From
03/12/2001 15:56:14
Eugenijus Rimkus
SPAB Siauliu energija
Siauliai, Lithuania
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00588652
Message ID:
00588917
Views:
25
thanks,
but then i use this command:
ALTER DATABASE personalas COLLATE SQL_Lithuanian_Cp1257_CI_AS

it show me to errors:
Server: Msg 5030, Level 16, State 2, Line 1
The database could not be exclusively locked to perform the operation.
Server: Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'personalas' cannot be set to SQL_Lithuanian_CP1257_CI_AS.


Eugenijus
Previous
Reply
Map
View

Click here to load this message in the networking platform