Re: Help with SQL errors in Profiler

From: Maciek Sarnowicz [MSFT] (macies_at_online.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 13:16:21 -0700

Hi,
Please make sure that you have events from TSQL group included in your
trace. The most useful would be:
SQL:StmtStarting or SQL:BatchStarting.

Regards,
Maciek Sarnowicz
SQL Server Tools SDE
-----------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.

"SalamElias" <eliassal@online.nospam> wrote in message
news:8FEBA1EB-DE4A-47B4-B154-A9B7532F17C3@microsoft.com...
>I noticed recently errors logged, each 5 second in the event viewer. I ran
> Profiler by adding Errors and warning, RPCcompleted, Stored proc...
> I see the same errors logged in profiler as the oners logged in event
> viewer
> but can not find the text or the SP generating the error. errors in
> Profiler
> appear as follows :
> Exception : Error: 208, Severity: 16, State: 1
>
> ErrorLog : 2004-09-23 09:24:43.82 spid66 Error: 208, Severity: 16,
> State: 1
> 2004-09-23 09:24:43.82 spid66 Invalid object name '##CC'...
> My web site continu to work and I don't see error messages on my pages.
> I use DBCC INPUTBUFFER(SPID), I get the following result :
> RPC Event 0 sp_executesql;1
>
> How can I configure or what should I do in my profiler to discover the
> statement or SP that causing the error. I should signal that just before
> error messages I have RPC:Completed messages for different SP

Relevant Pages

  • Help with SQL errors in Profiler
    ... each 5 second in the event viewer. ... Profiler by adding Errors and warning, RPCcompleted, Stored proc... ... My web site continu to work and I don't see error messages on my pages. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Insert that return Identity, any samples
    ... so I used sql profiler and I am even more confused now. ... get any error messages in profiler. ... I copy them into query analyzer and run them they work. ... The call in profiler showing my insert code ...
    (microsoft.public.biztalk.general)
  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
Loading