Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unicode Comparison Style
Message
General information
Forum:
Microsoft SQL Server
Category:
Installation
Miscellaneous
Thread ID:
00451066
Message ID:
00451079
Views:
33
>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?


Can this be on any help? This is what I get if I run SQLSERVR.EXE from the DOS prompt:
sing
2000-12-08 21:16:25.11 server   Directory Size: 5391
2000-12-08 21:16:25.11 spid1    Using dynamic lock allocation. [500] Lock Blocks
, [1000] Lock Owner Blocks
2000-12-08 21:16:25.11 spid1    Starting up database 'master'.
2000-12-08 21:16:25.11 spid1    Opening file d:\MSSQL7\data\master.mdf.
2000-12-08 21:16:25.12 spid1    Opening file d:\MSSQL7\data\mastlog.ldf.
2000-12-08 21:16:25.12 spid1    Loading SQL Server's  Unicode collation.
2000-12-08 21:16:25.12 spid1    Loading SQL Server's  non-Unicode sort order and
 character set.
2000-12-08 21:16:25.13 spid1    Error: 1817, Severity: 10, State: 4.
2000-12-08 21:16:25.13 spid1    Error: 1816, Severity: 16, State: 1.
2000-12-08 21:16:25.38 spid1    12/08/00 21:16:25 Stack Overflow Dump not possib
le - Exception c00000fd E at 00403268
2000-12-08 21:16:25.38 spid1    Address=403268 Exception Code = c00000fd
2000-12-08 21:16:25.38 spid1    eax=00000000 ebx=00000000 ecx=000b3300 edx=00000
01e
2000-12-08 21:16:25.38 spid1    esi=00000000 edi=0000001e eip=00403268 esp=01642
f64
2000-12-08 21:16:25.38 spid1    ebp=01643164 efl=00010202
2000-12-08 21:16:25.38 spid1    cs=1b ss=23 ds=23 es=23 fs=3b gs=0
AS you can see, I am completly desperate!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Reply
Map
View

Click here to load this message in the networking platform