SQL Server 7 - "Unicode Comparison" won't let me restore

I'm trying to recover after a hard disk crash, and was able to recover the
MDF and NDF of a database. When I try to attach it to a SQL 7 sp4 Database, 
I
get this message:
"Could not attach the database because the character set, sort order, or
Unicode collation for the database differs from this server.
Warning: Unicode comparison flags 196611 in database differs from server
Unicode comparison flags of 196609."
Is there any way I can get this in sync so that my SQL Server will be able
to utilize these files to bring the database back?
Thnx,
Bill R.
Chicago IL

Hi

I assume you have re-installed SQL Server with a different code page? The
easiest solution would be to un-install and re-install. Failing that you
could install a new instance and transfer the database across using the
Import/Export wizard or BCP.

John

"Rosman Computing" wrote:

> I'm trying to recover after a hard disk crash, and was able to recover the
> MDF and NDF of a database. When I try to attach it to a SQL 7 sp4 Database
, I
> get this message:
> "Could not attach the database because the character set, sort order, or
> Unicode collation for the database differs from this server.
> Warning: Unicode comparison flags 196611 in database differs from server
> Unicode comparison flags of 196609."
> Is there any way I can get this in sync so that my SQL Server will be able
> to utilize these files to bring the database back?
> Thnx,
> Bill R.
> Chicago IL
>

Are you able to tell, based on the error message I received, which Code Page
to reinstall? And which one i presently am using?
Right now I really don't have a database, I don't think, since it is just a
MDF and NDF file and hasn't been attached yet.
thanks,
bill r.

"John Bell" wrote:

> Hi
>
> I assume you have re-installed SQL Server with a different code page? The
> easiest solution would be to un-install and re-install. Failing that you
> could install a new instance and transfer the database across using the
> Import/Export wizard or BCP.
>
> John
>
> "Rosman Computing" wrote:
> 

Hi

I don't have an instance of SQL 7 available to me to check this, but if you
go into Enterprise Manager it should be on the properties pages for the
server. I assume that your documentation has not got the code page that was
used? The issue may be that you have different case sensitvity settings.

John

"Rosman Computing" wrote:

> Are you able to tell, based on the error message I received, which Code Pa
ge
> to reinstall? And which one i presently am using?
> Right now I really don't have a database, I don't think, since it is just 
a
> MDF and NDF file and hasn't been attached yet.
> thanks,
> bill r.
>
> "John Bell" wrote:
>