USE MASTER
GO
IF OBJECT_ID('sp_GetInputBuffer') IS NULL
EXEC ('CREATE PROCEDURE sp_GetInputBuffer AS SELECT 1 AS ID')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE sp_GetInputBuffer
@SPID SMALLINT = NULL,
@SQL NVARCHAR(4000) = NULL OUTPUT,
@PrintSQL BIT = 1
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
-- =============================================
-- Author: Gokhan Varol
-- Create date: 10/05/2010
-- Description: 1. Generates create and drop scripts for tables and it's constraints
-- =============================================
DECLARE @IBuf TABLE (EventType NVARCHAR(30) NULL,
PARAMETERS INT NULL,
EventInfo NVARCHAR(4000) NULL)
SET @SQL = 'DBCC INPUTBUFFER(' + ISNULL(CAST(@SPID AS VARCHAR), CAST(@@SPID AS VARCHAR)) + ') WITH NO_INFOMSGS'
INSERT @IBuf
EXEC (@SQL)
SELECT @SQL = EventInfo
FROM @IBuf
IF @PrintSQL = 1
PRINT @SQL
GO
EXEC sys.sp_ms_marksystemobject
sp_GetInputBuffer
GO