Hi

http://msdn.microsoft.com/library/de...grade_6nqr.asp

http://msdn.microsoft.com/library/de...grade_5jw3.asp
(and it's sub-pages)

http://support.microsoft.com/default...b;en-us;261334

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"cfmx" <kent@klhs.net> wrote in message
news:1111854538.017241.304760@l41g2000cwc.googlegr oups.com...
> I'm needing to move a database from SQL 7 to SQL 2000. What is the
> best way to accomplish this and keep all tables, data, permissions, etc
> in place throughout the move.
>
> Should I use BCP, Replication or something else?
>
> Thanks for any help.
>