Hello!
This repository contains utilities, tools, and queries developed by Switch Architecture and shared with the community to help other developers, architects, and administrators.
Description:
This script will create a utility stored procedure that will drop all #temporary tables that exist for the current session. It's helpful when you're debugging code that creates multiple #temporary tables and you need to execute the code multiple times.
More details on it's purpose and usage may be found in our article "Say goodbye to dropping #temporary tables".
Download
Installation Steps:
Run "Install [usp_Utility_DropTempTables].sql" Be sure to change to the appropriate database context first
Usage Example:
EXEC [dbo].[usp_Utility_DropTempTables];