How to access a table in sql2005 database from stored procedure in another database

[Shaimmaa]

Hi here is what I have 1- I have 2 different tables in 2 different databases 2- I need to write a stored procedure to start a transaction to add data in both tables so if any error occured then rollback so I want to access the table in the other database to add data to it any help thanks Shaimmaa

[Sankar Komma]

Get the data from one database table to anothter databse select * from databasename.dbo.tablename

smile :-)

[Mycroft Holmes]

Assumes the DBs are on the same server (valid assumprion from the ?) If the DBs are on different servers you will need to look into Linked servers (nasty things linked servers)

Never underestimate the power of human stupidity RAH