How to alter DBCC INPUTBUFFER text output

21 Oct 2005 6:57 PM

Chris

DBCC INPUTBUFFER(12) - This command returns what spid #12 is doing.

(1 row(s) affected)

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

I am 99% confident the output above "DBCC execution completed..." is choking
my VB.NET client on the objDataAdapter.Fill method...

How do I execute DBCC INPUTBUFFER to not display this above?

Thanks in advance,
Chris

21 Oct 2005 7:04 PM

Jerry Spivey

Chris,

Might try the fn_get_sql function (SP3+) instead.

See:

Find out what they're doing with fn_get_sql
http://www.databasejournal.com/features/mssql/article.php/2189761

HTH

Jerry
Show quote

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:3C78EEE0-4084-48C4-A346-30A7E33F14E4@microsoft.com...
>
> DBCC INPUTBUFFER(12) - This command returns what spid #12 is doing.
>
> (1 row(s) affected)
>
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
>
>
> I am 99% confident the output above "DBCC execution completed..." is
> choking
> my VB.NET client on the objDataAdapter.Fill method...
>
> How do I execute DBCC INPUTBUFFER to not display this above?
>
>
> Thanks in advance,
> Chris
>

21 Oct 2005 7:30 PM

Trey Walpole

to clarify: Which part do you think is choking .net? the count ("1 row(s)
affected") or the "execution completed" message?
The row count can be suppressed by passing "SET NOCOUNT ON" before the dbcc
command. I'm pretty sure the completion message cannot be suppressed.

That said, I've got this in a tools app, but don't have any problems with
it, without using set nocount.
What data adapter class are you using? Try using the SqlDataAdapter, if not
already using it. (in System.Data.SqlClient namespace).

Show quote

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:3C78EEE0-4084-48C4-A346-30A7E33F14E4@microsoft.com...
>
> DBCC INPUTBUFFER(12) - This command returns what spid #12 is doing.
>
> (1 row(s) affected)
>
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
>
>
> I am 99% confident the output above "DBCC execution completed..." is
> choking
> my VB.NET client on the objDataAdapter.Fill method...
>
> How do I execute DBCC INPUTBUFFER to not display this above?
>
>
> Thanks in advance,
> Chris
>