how to AUTOCOMMIT ON in SQL server 2005

Narasareddykr Narasareddykr is offline

Newbie

Join Date: Aug 2008

Posts: 1

#1: Aug 28 '08

Hi all,

i am new in SQL Server 2005. how to AUTOCOMMIT ON.

i am Try to Query/Query Option/Execute/ANSI IMPLICIT_TRANSACTIONS ON, and Tools/Options/Execute Query/ANSI IMPLICIT_TRANSACTIONS ON.

But no Auto Commit in My Database.

Problem is i am Executing Query in Front-End( .Net 2005 ), After Executing Query i am not Executing Commit Statement. thats why its not commit the database.

how to AUTOCOMMIT the database.

Thanks * Regards

Narasareddy

« previous question | next question »

Similar Microsoft SQL Server bytes

Ongoing purging of active records causes deadlocks (answers)
Disabling the AUTOCOMMIT option in MSSQLServer (answers)
mysql in a startup/shutdown loop at 30 sec intervals (answers)
Cannot use mail() in IE, only works in a debugger--help (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,501 network members.