Skip to content

Latest commit

 

History

History
105 lines (73 loc) · 3.08 KB

dbcc-outputbuffer-transact-sql.md

File metadata and controls

105 lines (73 loc) · 3.08 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
DBCC OUTPUTBUFFER (Transact-SQL)
DBCC OUTPUTBUFFER returns the current output buffer in hexadecimal and ASCII format for the specified session.
rwestMSFT
randolphwest
12/05/2022
sql
t-sql
language-reference
DBCC OUTPUTBUFFER
OUTPUTBUFFER_TSQL
OUTPUTBUFFER
DBCC_OUTPUTBUFFER_TSQL
DBCC OUTPUTBUFFER statement
output buffers
current output buffer
TSQL

DBCC OUTPUTBUFFER (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Arguments

session_id

The session ID associated with each active primary connection.

request_id

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.

Remarks

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

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

Result sets

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.

Permissions

Requires membership in the sysadmin fixed server role.

Examples

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

DBCC OUTPUTBUFFER (52);

See also