borra2005 (2/24/2010)
Hi,I have an SP, with in that SP there is a transaction, when i try to call another SP which is in other data base ans has a delete statement, i couldn't able to delete the record. But if i remove the transaction and call the delete SP, i could make it.
What is the way to use cross data base transactions?
Thanks in advance,
Borra.
What is the error that you are encountering?
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins