implicit txn

Hi ,
wat's exactly implicit transaction being turned on in the
db options ?
does it mean i have to supply a commit txn for the
changes to being written to the db ?
thks & rdgsHi,
In this mode you should either execute commit or rollback the transaction.
If you just disconnect all the transaction for that session
will be rolled back automatically.
This is actuall a session wide setting or server wide setting.
Session wide
SET IMPLICIT_TRANSACTIONS ON
Server wide
--
exec sp_configure N'user options', 2
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:cc2601c48a6a$1ce36e90$a401280a@.phx.gbl...
> Hi ,
> wat's exactly implicit transaction being turned on in the
> db options ?
> does it mean i have to supply a commit txn for the
> changes to being written to the db ?
> thks & rdgs|||Normally when you wish to have multiple statements grouped together in a
single transaction you must do a
Begin transaction... All work you do becomes part of the same group
transaction until you either commit or rollback the transaction.
Any statements (insert, update, delete) you make OUTSIDE of a begin tran,
commit pair are considered to be a transaction... Each statement is in it's
own transaction.
When you set implicit_transactions on, SQL Behaves differently.
Begin tran is no longer allowed, and almost EVERY statement you do
automatically begins a multi-statement transaction ( instead of each
statement being in it;s own tran.). Everything you do is aggregated into a
group transaction until you commit or rollback...
Most people do NOT use implicit_transactions.
BOL has more information ...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:cc2601c48a6a$1ce36e90$a401280a@.phx.gbl...
> Hi ,
> wat's exactly implicit transaction being turned on in the
> db options ?
> does it mean i have to supply a commit txn for the
> changes to being written to the db ?
> thks & rdgs