SQLize Online / PHPize Online  /  SQLtest Online

USE [master] GO CREATE PROCEDURE [dbo].[sp_GoAheadAndFireMe] AS BEGIN SET NOCOUNT ON IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp CREATE TABLE #temp ( id INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, cmd NVARCHAR(4000) ) INSERT [#temp] ( [cmd] ) SELECT N'DBCC WRITEPAGE (' + CAST([dddpa].[database_id] AS NVARCHAR(10)) + N', ' + CAST([dddpa].[allocated_page_file_id] AS NVARCHAR(10)) + N', ' + CAST([dddpa].[allocated_page_page_id] AS NVARCHAR(10)) + N', ' + N'0' + N', ' + N'4' + N', ' + N'0x0000008A' + N') WITH NO_INFOMSGS' AS [cmd] FROM [sys].[dm_db_database_page_allocations](2, NULL, NULL, NULL, 'DETAILED') AS [dddpa]; DECLARE @cmd NVARCHAR(4000); DECLARE @sql NVARCHAR(4000); DECLARE tempdb_killer CURSOR LOCAL FAST_FORWARD FOR SELECT [cmd] FROM [#temp] AS [t] OPEN tempdb_killer FETCH NEXT FROM tempdb_killer into @cmd WHILE @@FETCH_STATUS = 0 BEGIN SELECT @sql = N'SELECT TOP 1000 * INTO #crap_' + SUBSTRING(CAST(NEWID() AS VARCHAR(36)), 0, 9) + ' FROM sys.messages;' --One for the money EXEC(@cmd); EXEC(@sql); --Two for the show EXEC(@cmd); EXEC(@sql); --Three to get ready EXEC(@cmd); EXEC(@sql); --Now your server is dead FETCH NEXT FROM tempdb_killer into @cmd END CLOSE tempdb_killer DEALLOCATE tempdb_killer END;