Rollback Of Modification

[vksingh24]

Hi,

I have a question regarding the rollback of transaction

I have a table EMP

table structrue is: EmpID, DeptID

I fired this query accidently

update EMP set DeptID=10

NOW, its has modified all the rows.

How can I rollback this transaction.

Plsae let me know

[debasisdas]

have you tried using the rollback command ?

[vksingh24]

have you tried using the rollback command ?

I have not used any

begin transaction, commit transaction or rollback transaction

I simply open the SQL Query analyzer and fired the Query

[debasisdas]

Just rollback and check what happens.

[vksingh24]

Just rollback and check what happens.

It doesn't work.

Server: Msg 3903, Level 16, State 1, Line 1
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

[debasisdas]

if you have not committed then it will not be saved in database.

[ck9663]

if you have not committed then it will not be saved in database.

if you fire the query inside a sql analyzer or some other tool, i think that's immediately executed unless you explicitly define a transaction block. start looking for a backup...

-- ck