"Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message
news:O6%23X0$iyDHA.1740@TK2MSFTNGP09.phx.gbl...
> Queries aren't logged. The logs is for storing transactions such as
> UPDATEs, INSERTs and DELETE. There is no consistency that needs to be
> maintained with a SELECT. If it runs, it runs. If it stops that's it It
> doesn't make changes to a table. That is why you would need Profiler.
You
> know, you can save the transactions to a file for review in query
analyzer.
> Maybe that would help.
>
> If you wish to monitor logged transactions, there is some third party
> software out there. I have no experience nor recommendations with any.
> Lumigent is one company I've heard of who makes log explorer.
>
> Good luck.
>
>

"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message
news:uHVb3FjyDHA.3156@TK2MSFTNGP11.phx.gbl...
> I don't believe any product by Lumigent will allow you to track select
> statements.
>
> --
> Ray Higdon MCSE, MCDBA, CCNA
> ---
> "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message
> news:O6%23X0$iyDHA.1740@TK2MSFTNGP09.phx.gbl...
> > Queries aren't logged. The logs is for storing transactions such as
> > UPDATEs, INSERTs and DELETE. There is no consistency that needs to be
> > maintained with a SELECT. If it runs, it runs. If it stops that's it
It
> > doesn't make changes to a table. That is why you would need Profiler.
> You
> > know, you can save the transactions to a file for review in query
> analyzer.
> > Maybe that would help.
> >
> > If you wish to monitor logged transactions, there is some third party
> > software out there. I have no experience nor recommendations with any.
> > Lumigent is one company I've heard of who makes log explorer.
> >
> > Good luck.
> >
> >
>
>

>-----Original Message-----
>One that may help with this is from
http://www.sqlpower.com/. This allows a
>slimmed down profiler type monitoring but from a network
perspective. You
>would have to have it running to see what happened
though as it can not look
>back in time.
>
>--
>
>Andrew J. Kelly
>SQL Server MVP
>
>
>"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in
message
>news:uHVb3FjyDHA.3156@TK2MSFTNGP11.phx.gbl...
>> I don't believe any product by Lumigent will allow you
to track select
>> statements.
>>
>> --
>> Ray Higdon MCSE, MCDBA, CCNA
>> ---
>> "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com>
wrote in message
>> news:O6%23X0$iyDHA.1740@TK2MSFTNGP09.phx.gbl...
>> > Queries aren't logged. The logs is for storing
transactions such as
>> > UPDATEs, INSERTs and DELETE. There is no
consistency that needs to be
>> > maintained with a SELECT. If it runs, it runs. If
it stops that's it
>It
>> > doesn't make changes to a table. That is why you
would need Profiler.
>> You
>> > know, you can save the transactions to a file for
review in query
>> analyzer.
>> > Maybe that would help.
>> >
>> > If you wish to monitor logged transactions, there is
some third party
>> > software out there. I have no experience nor
recommendations with any.
>> > Lumigent is one company I've heard of who makes log
explorer.
>> >
>> > Good luck.
>> >
>> >
>>
>>
>
>
>.