Page 1 of 1

ms sql server and transaction

Posted: Thu Feb 27, 2003 12:12 am
by roguia
good morning

how to use transaction in sql server exple i have to update multiple tables in my database but if an error occured i want to annulate(rollback) the operations
thank you

Posted: Fri Feb 28, 2003 11:35 pm
by Jade
i'm not sure you can do that. However, I do know you can make a backup copy of the database and then restore it if something happens. You might want to look into that.

http://www.mysql.com/doc/en/BACKUP_TABLE.html

http://www.mysql.com/doc/en/RESTORE_TABLE.html


that may be your best and only bet.

ms sql server and transaction

Posted: Sun Mar 02, 2003 11:23 pm
by roguia
thank you :)

Posted: Mon Mar 03, 2003 10:54 am
by Beans
I thought you were talking about MS SQL Server?