Showing posts with label transactions. Show all posts
Showing posts with label transactions. Show all posts

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?