Tuesday, February 14, 2012

Cross database transactions.

Are Cross database transactions enabled by default? Not cross-server,
just cross database. If not what setting should I be looking at?Hi Frank
There is nothing special you need to do to enable cross database
transactions. Just make sure you have the necessary rights to the objects in
both databases.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Frank Rizzo" <none@.none.com> wrote in message
news:%238lZ7g24HHA.4964@.TK2MSFTNGP06.phx.gbl...
> Are Cross database transactions enabled by default? Not cross-server,
> just cross database. If not what setting should I be looking at?

No comments:

Post a Comment