I've worked with SQL and Oracle over the past few years and wonder if a feature in Oracle is available in SQL ... in our Oracle equivalent of Query Analyzer (etc), everything was transactional, so EVERY change had to be followed by either a COMMIT statement or by clicking the [tick] box

Is there some way of achieveing the same with SQL (I'm using 2008)

I know that I can start out with a BEGIN TRANSACTION, but at work, when the pressure is on, this gets forgotten ... and I've just done the classic

UPDATE <TABLE> SET <column> = 'value'

... and missed the WHERE clause

A sinking feeling when you see the line

284000 Records Updated



Lucky, my backup policy is good (phew!)

Any help appreciated.

__________________
Regards,

Sean

You can read about some options here:

http://forums.asp.net/p/1242243/2281619.aspx