Thankyou for quick answer about my last question.

More about 7.0 and 2000 sql servers:

Can I move a 7.0 database from a server which has this
different sort order to sql 2000 server which has this
different sort order and do it with "Copy database
Wizard" ?

2000 Installation white papers said that it is best
to choose a binary sort order (fastest), but some user
groups pages tell's that in some situation it can be not
so good idea thinking about best performance. Who should I
believe?

Moving anything between code pages is going to involve a lot of IO.

Using the "Copy SQL Server Objects" task then there is a Check box to "Use
Collation" remove that.

With SQL Server 2000 you have the opportunity though to have databases of
differing collations on the same server that differ from the Server
collation. You can also have tables of differing collations in each
database and going one step further columns of differing collations in the
same table

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\arc
hitec.chm::/8_ar_da_819v.htm



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Auli" <anonymous (AT) discussions (DOT) microsoft.com> wrote