help me out

i have to write 2 stored procs
in one sp i use table in one db
in 2nd sp i use table in another db
when should i use begin and end transaction
how to avoide deadlock issuesREAD BOL fro distributed transactions
and for the question how to retrive and join the table on adhock basis use
this
--
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=<your server name>.;User ID=<id>;Password=<password>'
).databasename.DBO.tablename INNER JOIN EMPLOYEES on STNO = staffno
--
Regards
R.D
--Knowledge gets doubled when shared
"raghu veer" wrote:

> i have to write 2 stored procs
> in one sp i use table in one db
> in 2nd sp i use table in another db
> when should i use begin and end transaction
> how to avoide deadlock issues|||Read This
http://msdn.microsoft.com/library/d...br />
9ar2.asp
--
Regards
R.D
--Knowledge gets doubled when shared
"raghu veer" wrote:

> i have to write 2 stored procs
> in one sp i use table in one db
> in 2nd sp i use table in another db
> when should i use begin and end transaction
> how to avoide deadlock issues