Attaching a database to SQL 7.0

I have tried to use the command SP_ATTACH_DB to add a
database to my SQL SERVER 7.0, but I get an error message
stating the unicode comparison flag 196611 of my database
is different from the one setup in my server 196609.
Does anybody know how to change this parameter? I have
reinstalled SQL several times testing the character set,
sort order and Unicode collation but nothing seems to
correct this error message.>
> I have tried to use the command SP_ATTACH_DB to add a
> database to my SQL SERVER 7.0, but I get an error message
> stating the unicode comparison flag 196611 of my database
> is different from the one setup in my server 196609.
> Does anybody know how to change this parameter? I have
> reinstalled SQL several times testing the character set,
> sort order and Unicode collation but nothing seems to
> correct this error message.
--
You need to rebuild your master database to conform to unicode comparison
flag = 196611 defined as follows:
Case-insensitive = 1
Accent-insensitive = 2
Width-insensitive = 65536
Kana-insensitive = 131072
Only then can you attach your database.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.