Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unicode Comparison Style
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Installation
Title:
Unicode Comparison Style
Miscellaneous
Thread ID:
00451066
Message ID:
00451066
Views:
76
I am in big trouble!

I am running SQL 7 (SP1). Somebody send me a backup of its database to debug a VB application.

I went to in Enterprise Manager and select restore backup. I received a message saying that my server and the backup were not of the same «unicode comparison style». I was set to 196611 and the backup was set to 196609.

I opened a Query analyzer session and run this:
sp_configure 'Unicode Comparison Style', 196609
reconfigure
The bad news is that I cannot re-start my SQL Server. I have shut down the computer and restarted it.

When I look in the event viewer I see 2 messages:
1- 18052 : Error: 1816, Severity: 16, State: 1.
2- 18052 : Error: 1817, Severity: 10, State: 4.

What can I do?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Next
Reply
Map
View

Click here to load this message in the networking platform