MSSQLTips

Hello SQL Experts

 One of my friends had to update the changeid of one user(userid =1000) to 100. But while updating he forgot to include "begin tran .. commit\rollback" and missed to include the "where ..." statement and it updated aginst all the users with changeid as 100.

Is there any way to rolback this change?

Please assist.

Regards

 Did you find a way to fix it ?

For next time, I can offer  atool for SQL  Version Control - It shifts the responsibility for versioning from the users to the software. Its light-weight, easy to use tool that runs in the background and keeps track of all your databases schema and data changes over time, and enables full review of databases' history, and full rollback to any point in time, as well as optionally push changes into existing systems (Subversion, SourceSafe or Team Foundation Server).

 You've committed the change so now it's hardened to the database.  You can't undo it without issuing another update statement to re-change the value.