GilaMonster (7/18/2008)
shiwani2002sg (7/18/2008)
if by chance i run a delete command ,n sme rows from some table get deleted ,then what is the command to rollback the command or immediate command. so that i can retrieve the deleted rowsUnless you started an explicit transaction before you ran the delete, there is no command that will retrieve the rows. You will have to locate a backup of the database.
If you need to revert to the backup, you may even want to explore some third party tools that allow you to do table and row level restore using the SQL Server backup. If the backup is older than you need, and you are desperate, you can also dig out a lot of information about the deleted rows from the transaction log.
Regards,
Andras