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.

 All Forums
 Other Forums
 Other Topics
 transactional table creation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-29 : 11:28:51
pradeep nayak writes "hi there

the tables being created in my mysql are becoming non-transactional by default, they dont support rollback operation
when i try to rollback im getting an error message which goes like this " [localhost] ERROR 1196 warning : some non-transactional tables could not be rolled back. "

i' ve learnt that creation of transactional tables is possible which support rollback operation
please tell me how to create tables which are transactional so that i can execute the rollback operation

thanks"

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2004-06-30 : 05:08:30
I'd advise going to a MYSQL forum first.....sqlteam.com is 95%+ dedicated to MSSQLServer.
one option for you is www.dbforums.com
Go to Top of Page
   

- Advertisement -