Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore won't restore if from a different sort order
Message
From
28/01/1999 16:29:39
 
 
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00180994
Message ID:
00181552
Views:
13
>>Has someone forgotten to include the ID at the right of those items when we rebuilt the master database and select the sort ID or has forgotten to change this technical ID message to a more logical message when we want to restore a backup? :)
>
>Probably both. FYI you can use sp_helpsort to retrieve the character set and sort order that is installed on your server.

Well, the message was saying the sort ID to be 42. IAC, it's good to know that we can extract this value anytime. :)
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform