ms sql server and transaction

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
roguia
Forum Newbie
Posts: 8
Joined: Thu Feb 27, 2003 12:12 am

ms sql server and transaction

Post 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
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Post 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.
roguia
Forum Newbie
Posts: 8
Joined: Thu Feb 27, 2003 12:12 am

ms sql server and transaction

Post by roguia »

thank you :)
Beans
Forum Commoner
Posts: 49
Joined: Mon Dec 23, 2002 3:06 am
Location: Manila, Philippines
Contact:

Post by Beans »

I thought you were talking about MS SQL Server?
Post Reply