Hi all,
I just want to copy a table structure or a table structure and data to
another database.
Whats the easiest way to do it?

I've been just copy/pasting in enterprise manager.

Thanks,
baz

In message <eNF8vl9VEHA.3380 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Barry G. Sumpter
<barrysum (AT) bigpond (DOT) net.au> writes
If you want all structures and data then try a backup and restore.

If you want a more granular level the Copy SQL Server Objects Task may
be a good bet, from within DTS. The is also available through the Wizard
if you select the "Copy objects and data between SQL Server database"
option on about the 3rd or 4th screen.

Depending on your requirements for structires only, you may find that
using Enterprise Manager to generate scripts (Right-click DB, All Tasls,
Generate SQL Scripts) does the job well enough, or there are other third
party tools that do a similar job, often with more features when it
comes to scripting.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org