Posted by Uri Dimant on 03/05/07 11:21

Dylan
Take a look at SQL Server Profiler to capture those events



"Dylan Parry" <usenet@dylanparry.com> wrote in message
news:45ebf17a$0$762$bed64819@news.gradwell.net...
> Hi,
>
> I am trying to debug some queries that are being generated by an
> external program, and I have no way of finding out what the actual
> syntax of the query is from within the program itself. This means that
> when the query fails I am left with only a very unhelpful message.
>
> So what I was wondering, was whether there is a way that I can view the
> actual queries that are sent to SQL server as they happen, or if a
> real-time solution doesn't exist, then some way I can look back after
> the event and see the syntax of the queries?
>
> Ideally, what I would like to do is see the queries in the form they
> were sent to the server, ie "SELECT * FROM foo WHERE bar='foobar'", as
> this would help me to figure out where the generated queries are going
> wrong.
>
> Cheers,
>
> --
> Dylan Parry
> http://electricfreedom.org | http://webpageworkshop.co.uk
>
> The opinions stated above are not necessarily representative of
> those of my cats. All opinions expressed are entirely your own.

[Back to original message]