What does REVERT do in SQL Server 2005?
Ankur Jain
Answer Restores your previous execution context.Explanation If you have changed your execution context with EXECUTE AS, the REVERT statement will restore the last context prior to the EXECUTE AS.
It restores your previous execution context. If you have changed your execution context with EXECUTE AS, the REVERT statement will restore the last context prior to the EXECUTE AS
Restores your previous execution context.If you have changed your execution context with EXECUTE AS, the REVERT statement will restore the last context prior to the EXECUTE AS.