MSSQL

EXEC sp_MSforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

EXEC sp_MSforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

USE master;
ALTER DATABASE [database] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [database];

CREATE LOGIN [login_name] WITH PASSWORD = '[login_password]';

CREATE USER [user_name] for login [login_name]

GRANT SELECT, INSERT, UPDATE, DELETE on [schema.object] to [user_name];

SELECT * FROM sys.dm_exec_sessions WHERE status = 'running';
OR
EXEC sp_who;

BEGIN TRAN  
SELECT 1 FROM dbo.Members WITH (TABLOCKX)
WAITFOR DELAY '00:00:30' 
ROLLBACK TRAN   
GO 

SELECT * FROM dbo.Members WITH (ROWLOCK, UPDLOCK)
WHERE ID = 2