>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?


Also, can I restore a database without having this paramameter set to the same vlaue?