Generate SQL script to replicate the content of a table ?

Hi,

In SQL Server 2000, is it possible to generate a SQL script out of a table so that I can take that script file and execute on another server to replicate the table in the first database. It means, the script file will contain all the INSERT statements to insert records into the new table.

I know I can use the "Import and Export" functionality to transfer data between 2 servers; but because I am behind the firewall, I cannot do that.

Any help is really appreciated.

Thanks.http://www.mssqlcity.com/Scripts/ImpExp/DataAsInsertCommand.sql is a tool that creates a script.|||thanks a lot. That's exactly what I'm looking for.