CREATE PROCEDURE usp_TempCleanUp
	AS
BEGIN
	SET NOCOUNT ON
	DECLARE @Table varchar( 1024 )

	DECLARE Tables_cursor CURSOR FOR 
		SELECT name 
			FROM tempdb..sysobjects
			WHERE xtype =  "U" 

	OPEN Tables_cursor

	FETCH NEXT FROM Tables_cursor 
	INTO @Table

	WHILE @@FETCH_STATUS =  0 
	BEGIN
		 /* Удаление таблицы */ 
		EXEC( 'DROP TABLE ' + @Table ) 
		IF @@ERROR <>  0 
			PRINT 'Cannot drop the table: ' + @Table
		ELSE
			PRINT 'Table is dropped: ' + @Table

		FETCH NEXT FROM Tables_cursor 
		INTO @Table
	END
	CLOSE Tables_cursor
	DEALLOCATE Tables_cursor
	SET NOCOUNT OFF
END

EXEC usp_TempCleanUp
DBCC SHRINKDATABASE('tempdb')