DBCC OUTPUTBUFFER (Transact-SQL)

DBCC OUTPUTBUFFER (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the current output buffer in hexadecimal and ASCII format for the specified session_id.

Topic link icon Transact-SQL Syntax Conventions

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

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
Allows for options to be specified.

NO_INFOMSGS
Suppresses all informational messages that have severity levels from 0 through 10.

DBCC OUTPUTBUFFER displays the results sent to the specified client (session_id). For processes that do not contain output streams, an error message is returned.

To show the statement executed that returned the results displayed by DBCC OUTPUTBUFFER, execute DBCC INPUTBUFFER.

DBCC OUTPUTBUFFER returns the following (values may vary):

Output Buffer                                                              
------------------------------------------------------------------------   
01fb8028:  04 00 01 5f 00 00 00 00 e3 1b 00 01 06 6d 00 61  ..._.........m.a  
01fb8038:  00 73 00 74 00 65 00 72 00 06 6d 00 61 00 73 00  .s.t.e.r..m.a.s.  
'...'  
01fb8218:  04 17 00 00 00 00 00 d1 04 18 00 00 00 00 00 d1  ................  
01fb8228:   .  
  
(33 row(s) affected)  
  
DBCC execution completed. If DBCC printed error messages, contact your system administrator.  

Requires membership in the sysadmin fixed server role.

The following example returns current output buffer information for an assumed session ID of 52.

DBCC OUTPUTBUFFER (52);  

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

Community Additions

ADD
Show:
© 2016 Microsoft