Hi copy a table form one database to another database

#1

Hi is their any way around to copy a table from one database to another
database on same server using store procedure not DTS thanks

#2

try this:

use <destination db>
go
select * into < new table name> from <source db>.<owner>.<table name>
this will copy the data only. you will have to re-create any triggers,
indexes, etc manually after the data copy.

"amjad" wrote:

Quote:

Hi is their any way around to copy a table from one database to another
database on same server using store procedure not DTS thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Hi copy a table form one database to another database

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Hi copy a table form one database to another database - 05-10-2006 , 08:31 AM

RE: Hi copy a table form one database to another database - 05-10-2006 , 12:44 PM