DBCC INPUTBUFFER (Transact-SQL)

Displays the last statement sent from a client to an instance of Microsoft SQL Server 2005.

Topic link iconTransact-SQL Syntax Conventions

Syntax

DBCC INPUTBUFFER ( session_id [ , request_id ] )
[WITH NO_INFOMSGS ]

Arguments

  • session_id
    Is the session ID associated with each active primary connection.
  • request_id
    Is the exact request (batch) to search for within the current session.

    The following query returns request_id:

    SELECT request_id 
    FROM sys.dm_exec_requests 
    WHERE session_id = @@spid
    
  • WITH
    Enables options to be specified.
  • NO_INFOMSGS
    Suppresses all informational messages that have severity levels from 0 through 10.

Result Sets

DBCC INPUTBUFFER returns a rowset with the following columns.

Column name Data type Description

EventType

nvarchar(30)

Event type. This could be RPC Event or Language Event. The output will be No Event when no last event was detected.

Parameters

int

0 = Text

1- n = Parameters

EventInfo

nvarchar(4000)

For an EventType of RPC, EventInfo contains only the procedure name. For an EventType of Language, only the first 4000 characters of the event are displayed.

For example, DBCC INPUTBUFFER returns the following result set when the last event in the buffer is DBCC INPUTBUFFER(11).

EventType      Parameters EventInfo             
-------------- ---------- --------------------- 
Language Event 0          DBCC INPUTBUFFER (11)

(1 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Permissions

Requires one of the following:

  • User must be a member of the sysadmin fixed server role.

  • User must have VIEW SERVER STATE permission.

  • session_id must be the same as the session ID on which the command is being run. To determine the session ID execute the following query:

    SELECT @@spid
    

Examples

The following example runs DBCC INPUTBUFFER on a second connection while a long transaction is running on a previous connection.

CREATE TABLE T1 (Col1 int, Col2 char(3));
GO
DECLARE @i int;
SELECT @i = 0
BEGIN TRAN
SELECT @i = 0
WHILE (@i < 100000)
BEGIN
INSERT INTO T1 VALUES (@i, CAST(@i AS char(3)))
SELECT @i = @i + 1
END;
COMMIT TRAN;
--Start new connection #2.
DBCC INPUTBUFFER (52); 

See Also

Reference

DBCC (Transact-SQL)
sp_who (Transact-SQL)
Trace Flags (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

5 December 2005

Changed content:
  • Reworded the Result Sets descriptions for clarity.
  • Added more information to the Permissions section.