Re: sql server transaction configuration.

Hi,

For question 1, 2 and 3 the direct answer is "NO".

Thanks
Hari
SQL Server MVP

"sameer" <sameer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:69F96708-8A85-46F5-885E-96A07B162F60@xxxxxxxxxxxxxxxx
> 1. is there any way i can totally switch off transactions in sql server so
> that even if there are several statements with in a begin and
> commit\rollback
> transaction , without waiting for either the commit or rollback , it just
> commits all the changes.
>
> 2. If there is how can i swith it back to ON again.
>
> 3. Is there any default timeout value for a transaction ( not talking
> about
> deadlock or locking timeouts) after which even if the query is doing
> inserts\
> updates it rollsback everthing.
>
> please suggest.
> thanks
>


.

Relevant Pages

  • Re: Locking and Delay in a Bottleneck
    ... Invoices, Purchasing, etc) are generating a journal voucher accompanying ... the saving transaction, this journal voucher is having a header table ... number in a table whereupon you commit. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: Locking and Delay in a Bottleneck
    ... requirement that there be no gaps. ... the saving transaction, this journal voucher is having a header table ... number in a table whereupon you commit. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 7 vs. 2000 issue -trigger and nulls
    ... >We're having trouble with a trigger updating some tables. ... course be locked by the current transaction, ... locking data and updating rows when the COMMIT inside the trigger is ... I seriously hope that SQL Server 7.0 simply disregarded these two ...
    (microsoft.public.sqlserver.mseq)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Re: Multi-Database Transactions
    ... SQL Server has supported the concept of cross-database (or even cross ... "2-phase commit". ... > I've been looking into adding transaction capabilities into my object ... people were talking about data _sources_ instead of databases. ...
    (microsoft.public.dotnet.framework.adonet)