Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
misterraj
Yak Posting Veteran
94 Posts |
 Posted - 2006-11-20 : 23:35:03
|
i have some few qns:1)In sql-server 2005, how to set the auto-commit OFF ? where are these changes present.2)also, in a transaction if i delete some rows in a table and then roll-back, does these records come once again?3) if there is a network problem or database shuts down during the updation will it roll-back to the state where it was?thanks. |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2006-11-21 : 00:16:47
|
| 1) No idea. It is a runtime setting in SQL 72)Yes3)YesDavidMProduction is just another testing cycle |
 |
|
|
misterraj
Yak Posting Veteran
94 Posts |
Posted - 2006-11-21 : 00:49:31
|
| thanks for 2) and 3) but 1) remains un-answered stillwhat are the ways to set the auto-commit on or off at the database level or at the server level?is there anyway to commit/uncommit these transactions mention from the ado/ado.net level |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-11-21 : 02:21:41
|
| I don't think you can change that option for auto-commit, only back in Sybase you can, not in SQL anymore. I think |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-21 : 08:18:25
|
| From SQL Server 2000 Books Online:"SET IMPLICIT_TRANSACTIONSSets implicit transaction mode for the connection.SyntaxSET IMPLICIT_TRANSACTIONS { ON | OFF }RemarksWhen ON, SET IMPLICIT_TRANSACTIONS sets the connection into implicit transaction mode. When OFF, it returns the connection to autocommit transaction mode."CODO ERGO SUM |
|
|
|
|
|
|
turn autocommit off