Just need verification on something here.<br><br>If using a query like [INSERT INTO table1 (...) SELECT ... FROM table2 ...], will Sql Server rollback if an error is ...

I would like the user to have the ability to view the last three edits (create, update, delete) to any user editable field. Then, without needing to directly use SQL, say through a drop down list, ...