mssql7 to mssql200 transfer tables

I have a table in mssql7 that has 7000000 record and I want to take
100000 records out of it and place them into the new machine with
mssql2000. The new machine will also have the same table name, so I
want to append the 100000 records into that table.

Thanks,
Royal344
--
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.ms-sqlserverroyal344 (royal344.news.invalid@.web2news.net) writes:
> I have a table in mssql7 that has 7000000 record and I want to take
> 100000 records out of it and place them into the new machine with
> mssql2000. The new machine will also have the same table name, so I
> want to append the 100000 records into that table.

Do you want any 100000 rows?

You could use BCP and make use of the options for specifying first and
last row. I don't recall the exact name for these options right, but
you can look up the syntax for BCP in Books Online.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp