--------------------------------------------------------------------------------
--  File        :   Demo 11_Clean up.sql
--
--  Purpose     :   This script reverses the changes that are made as part of 
--                  the presentation's demonstrations.  The contents of each 
--                  comment block should be selected/highlighted and then run.
--
--  SQL Server  :   SQL Server 2005 (9.0)
--                  SQL Server 2008 (10.0)
--                  SQL Server 2008 R2 (10.5)
--
--  Version     :   3.0006.0090.0018 (2010-05-31)
--------------------------------------------------------------------------------

USE [tempdb];

GO

/*
EXECUTE [sys].[sp_cycle_errorlog];
*/
/*
EXECUTE [master].[sys].[sp_altermessage]
	@message_id = 1205,
	@parameter = 'WITH_LOG',
	@parameter_value = 'false';
*/
/*
DBCC TRACEOFF
(
	3605,
	1204,
	-1
);
*/
/*
DBCC TRACEOFF
(
	3605,
	1222,
	-1
);
*/
