DECLARE @Formatos TABLE(
	Codigo INT,
	Formato VARCHAR(255)
)

DECLARE @Count INT = 0

WHILE @Count < 200
BEGIN
		BEGIN TRY
			INSERT INTO @Formatos VALUES(@Count,convert(varchar(50),getdate(),@Count))
		END TRY  
		BEGIN CATCH  
     
		END CATCH
		SET @Count = @Count + 1
END

SELECT * FROM @Formatos

USE [master];

DECLARE @kill varchar(MAX) = '';

SELECT
		@kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM
		sys.dm_exec_sessions
WHERE
		database_id  = db_id('BANCO_DE_DADOS')

EXEC(@kill);

CREATE TABLE #sp_who2
(
	SPID INT,Status VARCHAR(255),
	Login  VARCHAR(255),HostName  VARCHAR(255),
	BlkBy  VARCHAR(255),DBName  VARCHAR(255),
	Command VARCHAR(255),CPUTime INT,
	DiskIO INT,LastBatch VARCHAR(255),
	ProgramName VARCHAR(255),SPID2 INT,
	REQUESTID INT
)

INSERT INTO #sp_who2 EXEC sp_who2

SELECT
		*
FROM
		#sp_who2
WHERE
		DBName <> 'master'
		AND DBName = 'BANCO_DE_DADOS'
		AND ProgramName <> 'Microsoft SQL Server Management Studio - Query'
ORDER BY
		DBName ASC

DROP TABLE #sp_who2