ROLLBACK is used when you have an open transaction to undo the changes for that transaction. It doesn't work after transactions have already been committed. This article [/url]I wrote at Simple-Talk goes over the basics of how to use transactions.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" - Theodore Roosevelt