Re: Invalid Buffer 17805

Try using something like:
Exceptions from the Errors and Warnings event class.
SQL:StmtStarting from the T-SQL event classes
SP:Starting and SP:StmtStarting from the Stored Procedures
event classes.
Filters depend on your system. Leave the application not
like SQL Profiler filter in there and additionally add at
least SQLAgent% in the same not like application filter.

-Sue

On 8 Nov 2005 06:28:15 -0800, "salvoWJ"
<salvatore.toro@xxxxxxxxxxxxxx> wrote:

>Hello
>
>I am running SQL Server 2000 with SP 4 on Windows Server 2003
>Enterprice Edisction.
>I receive several notifications with the following:
>
>Error: Message not found. Insertion strings:Error: 17805, Severity: 20,
> 3 Invalid buffer received from client.
>
>I want to create a SQL Profiler trace that will help me to identify
>which
>sql statements \ stored procedures are causing this error. What will i
>need
>to specify in the trace to identify the transaction that is causing
>this
>error and what kind of filter if any do i need to apply?
>
>I catch the error with SQLagent Alerts, but I want to known what
>statement or SP lanch the error.
>
>
>Help me please
>
>Salvo

.

Relevant Pages

  • Re: Stored Procedures Data view webparts
    ... and diagnose with SQL profiler. ... Got another issue though i cannot filter the contents? ... have these problems with stored procedures and filtering the data. ...
    (microsoft.public.sharepoint.portalserver)
  • SQL Profiler
    ... with SQL profiler. ... they say to include some Event Classes and some Data Columns that I do ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • SQL Profiler
    ... with SQL profiler. ... they say to include some Event Classes and some Data Columns that I do ... Prev by Date: ...
    (microsoft.public.sqlserver.tools)
Loading