Re: hi
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Mon, 17 Sep 2007 11:34:39 +0300
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
.
- References:
- Re: hi
- From: Ekrem Önsoy
- Re: hi
- Prev by Date: Re: SQL 2005, sysobjects and security
- Next by Date: RE: Application "Failure Audit" Event
- Previous by thread: Re: hi
- Index(es):
Relevant Pages
|
|
