Re: sort order ID
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/30/04
- Next message: vasum: "MSSQL 2000 Standard Edition not utilizing Maximum Memory!!!"
- Previous message: jwalker_at_wp.shawcable.net: "Me biteing my budgies head off"
- In reply to: Jagdish: "sort order ID"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 16:28:21 +0530
Hi,
SQL Server allows to create different collations for each database inside
one SQL Server. So create a database based on the SQL 7
collation and try to attach the database.
Get the equalent collations in SQL 2000 from books online. Search in index
for "collations, SQL collations"
Thanks
Hari
MCDBA
"Jagdish" <jnasit_x@hss.hns.com> wrote in message
news:67f801c42e9d$c26c09e0$a501280a@phx.gbl...
> I am migrting database from Sql Server 7 to SQL Server
> 2000. When i try to attach database in sql server 2000
> it's giving error like "Difference in sort order id 51 and
> 52 collations differece from server.
>
> please help me
- Next message: vasum: "MSSQL 2000 Standard Edition not utilizing Maximum Memory!!!"
- Previous message: jwalker_at_wp.shawcable.net: "Me biteing my budgies head off"
- In reply to: Jagdish: "sort order ID"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
