By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,660 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,660 IT Pros & Developers. It's quick & easy.

how to AUTOCOMMIT ON in SQL server 2005

P: 1
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
Aug 28 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.