Copy Table + data from database A to database B

Hi:
I'm really new to this DBA stuff and I need an explanation for what just happened.
I just used the copy wizard to copy Table A from database A to database B.
All the data and the table structure were successfully created in database B with one exception: the first column had
the IDENTITY (1,1) attribute set in database A. But after the copy to database B the IDENTITY attribute was missing!!!
Fortunately, I'm one of those inveterate "testers" so I discovered the problem before it made it into Production.
Eventually, I had to generate a script for the table to create that table in database B with the IDENTITY in place and
then import the data.
Anyone have any idea what the problem is and how to solve it' I don't like the idea of having to generate a script for
each table that I need to move and then import the data!!!! The copy wizard is a gem if it works as advertised!
Using SQL Server 7.0.
cathyThe copy table option only copies the data. If you want to copy all the
attributes you should use the Copy objects and data between SQL Server
databases.
The copy table option was designe to allow data transfers between
heterogenous data sources.
Rand
This posting is provided "as is" with no warranties and confers no rights.