Hi,

I have a typical situation .. if somebody cd throw their experience wd be of gr8 help.

I have a diff. db backup bak01.bak of different sort order say [52] and the sql i have installed and running live (in production) has sort order [43]. I wd like to restore the backup bak01.bak on the server having [43]. And i get the error unable to restore becoz of diff sort order.. !!. Well is there ne way, i can overcome this problem.. as we can't afford another sql installed for restoring the bak.. criticality is high !!!!!
Regards,

Shyam Viking.Y.

MS Sql Server LazyDBA home page