SQL Server 2000:
I would like to copy data, primary keys, identitiy columns, default values, etc from a particular table (products) and make a copy of it on another SQL server.
Please advise how can this be accomplished.
Would DTS be the simplest way to go? or is there a quicker and cleaner way to do this?