Transaction Rollback

USE master;

GO

ALTER DATABASE AdventureWorks

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

ALTER DATABASE AdventureWorks

SET MULTI_USER;

GO

Running above script will give following result.

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.