Re: SQL Profiler does not show error 170 severity level 15

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 17:34:23 -0000

I consulted Microsoft about this, and it turns out to be a known bug. 

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Cristiano Matheus" <anonymous@discussions.microsoft.com> wrote in message
news:2E11229E-AD7E-4212-BF08-740480878C4D@microsoft.com...
Does any one know why SQL Server Profiler does not show error 170?
I have an app that returns an error 170 "Incorrect syntax near..." and when
I use SQL Profiler to find the incorrect statement, this error does not show
up.
Thanks.
Cristiano Matheus

Relevant Pages

  • Re: fine tuned tracing for sql server job execution
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I'm thinking of using sql server profiler and/or the windows performance> logs, to trace a problematic job which> fails to retrieve any rows by executing a dts (which inbcludes transfare> data tasks). ...
    (microsoft.public.sqlserver.dts)
  • Re: DataSet transfer data from one database to another
    ... "Incorrect syntax near the keyword "in". ... OleDBConnection1 is a connection to my local SQL Server database. ... No this only works with the Jet Provider or with ISAM drivers used in conjunction with the Jet ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Profiler and transaction logs...
    ... off by the rather steep price tag - which, for what is likely to be a ... Profiler can't "replay transaction logs".. ... Is it possible to use SQL Server Profiler to replay a transaction log? ...
    (microsoft.public.sqlserver.tools)
  • Re: Procedure xxx expects parameter @ID which was not supplied
    ... why use Odbc when connecting to SQL Server? ... the System.Data.SqlClient namespace. ... run an instance of SQL Server profiler and see what ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL Keywords
    ... >I am attempting to import an XML file into SQL Server using XML Bulk Load. ... > One of the tables is named 'Plan', and importing into it causes the ... "Incorrect syntax near the keyword 'Plan'". ... > What is the correct syntax for a SQL keyword? ...
    (microsoft.public.sqlserver.xml)