hai,
   I want to copy data from one data base table to to other data base table using a stored procedure. How can i write Tsql command to transfer.
              thanks in advance.





vamsi

__________________
vamsi Krishna G
mobile: 91 + 9986023966.
124 Puttappa layout new Tippasandhra,
bangalore.
Inida

insert into db1.dbo.table1
select * from
db2.dbo.table1



------------------------------------------ http://sqlservercode.blogspot.com/

i want to check weather those tables are same or not before transfering data. Is there any way to do it.

regards

vamsi