[dba-SQLServer] Any gut feelings?

John,

Can I claim this one too?  

<snip>Next YouDaMan prize goes to the one who provides the syntax to
transfer an entire table - structure, data and indexes intact, from one db
to another. That ought to slow you folks down! <snip>

Check out Data Transformation Service (DTS) in Enterprise Manager.  There is
a wizard that walks you through it.  You set up the from connection (server
and database) and to connection (server and database).  You pick the objects
you want to transfer and off they go.

Doris Manning
Hargrove Inc.