What is transaction server auto commit?
- 1 Answers
- 1164 Views
- I also Faced
- E-Mail Answers
Answer / Najim Ali
Auto commit in SQL Server refers to the default behavior where each statement executed within a connection automatically commits after it completes, unless an explicit transaction has been started. This can be disabled using the SET IMPLICIT_TRANSACTIONS OFF command.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the source of constraints?
What is mean by dml?
What is the use of sign function?
What is the difference between for xml raw and for xml auto?
Tell me what is a linked server?
Explain time data type in sal server 2008?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
what is performance tunning in sql server ? explain.
What are the advantages of passing name-value pairs as parameters?
When a primary key constraint is included in a table, what other constraints does this imply?
How to throw custom exception in Stored Procedure?
What is the recovery model?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
