Re: hi

Yep, for sure. Profiler catches ad-hocs too.

You just need to configure your trace correctly. Please study on the link that I've given you last day.

Especially read about the Events Selection. There you'll find your answers and much more which will be very helpful for you I believe.


--
Ekrem Önsoy



"Pure Heart" <PureHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B519CB24-5AAF-40F3-BC77-845040B66C16@xxxxxxxxxxxxxxxx
hi. thanx for help

but if user uses ado.net in he application without the use of stored
procedure ot transact-sql
will profiler trace also ?
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


"Ekrem Önsoy" wrote:

Did you have a look at SQL Server Profiler?

Using SQL Server Profiler:
http://msdn2.microsoft.com/en-us/library/ms187929.aspx

--
Ekrem Önsoy



"Pure Heart" <PureHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1F9C1974-9E44-4111-AE55-78CDBA1DB0E2@xxxxxxxxxxxxxxxx
>i want to know haw can i monitor all activity user do in sql 2005, what
> values he changed, the new values and old values, records he deleted > and
> there values every thing, is there any tool or add-in to do so ?
>
> i got responces about code or scripts but wasnt convinced with it, is
> there
> may third party tool to do so ?
>
> thank you
> -- > Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643


.

Relevant Pages

  • Re: Application Trace Profiler
    ... Take SQL Server Profiler as an example. ... you wanting to just attach to it and find out what's going on with it? ... process and capture Trace.WriteLine calls like in SQL Server Profiler? ...
    (microsoft.public.dotnet.general)
  • SQL Profiler - Including NT users
    ... I try to profile queries with "SQL Server Profiler". ... "DHuppe" is my Nt user name. ...
    (microsoft.public.sqlserver.server)
  • Re: How to tracking trigger
    ... the production and I cannot have a right to run Profiler for this (my sql ... Thana N. ... > Run SQL Server Profiler to capture SP:StmtCompleted event. ...
    (microsoft.public.sqlserver.programming)
  • Re: Question on C2 Log
    ... > Why not using Profiler? ... > Support WebCast: How to Effectively Use SQL Server Profiler ... > Online Partner Support Specialist ...
    (microsoft.public.sqlserver.security)