Dylan Peters CaptainDylan

## Swapping-In-Tables-With-Switch-Partition.sql
/* Note: don't run this all at once. There are prompts to run some queries in another session, etc. */

WHILE @@trancount > 0
	ROLLBACK
GO

USE master;
GO

IF DB_ID('lockingtest') IS NOT NULL
	/* Note: don't run this all at once. There are prompts to run some queries in another session, etc. */

	WHILE @@trancount > 0
	ROLLBACK
	GO

	USE master;
	GO

	IF DB_ID('lockingtest') IS NOT NULL