Copy Table Data via StoreProcedures

Hi All.
How can I easily copy the data from one table of a SQL Database another Table residing on a Different SQL Database (Same server) via a StoredProcedure. Is there something like a copy to command?
Thanks in advance
you should be using DTS for this.
If you are hung up on a stored procedure do something like this
create procedure test as
insert into db2.dbo.tablename
select * from db1.tablename
"Guillermo" <anonymous@.discussions.microsoft.com> wrote in message
news:7CF43898-B81F-4504-BB1C-870906EFCC41@.microsoft.com...
> Hi All.
> How can I easily copy the data from one table of a SQL Database another
Table residing on a Different SQL Database (Same server) via a
StoredProcedure. Is there something like a copy to command?
> Thanks in advance