Hello, My company wants to track activity on SQL that
happens outside of the Applications that use it. For
instance if someone modifies a table in someway (Query
Analyzer, ASP, vbscript) without using the Application
that is intended to do it. Could someone point me in the
right direction on enabling this on SQL, or recommend a
product.
ThanksStart a Profiler Trace and add the valid app names to the filter on
ApplicationName NOT Like...
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Rog" <anonymous@.discussions.microsoft.com> wrote in message
news:9a6c01c405f8$cfc8d410$a401280a@.phx.gbl...
Hello, My company wants to track activity on SQL that
happens outside of the Applications that use it. For
instance if someone modifies a table in someway (Query
Analyzer, ASP, vbscript) without using the Application
that is intended to do it. Could someone point me in the
right direction on enabling this on SQL, or recommend a
product.
Thanks|||You might look at Lumigent's tool called Entegra. www.lumigent.com
Ray Higdon MCSE, MCDBA, CCNA
--
"Rog" <anonymous@.discussions.microsoft.com> wrote in message
news:9a6c01c405f8$cfc8d410$a401280a@.phx.gbl...
> Hello, My company wants to track activity on SQL that
> happens outside of the Applications that use it. For
> instance if someone modifies a table in someway (Query
> Analyzer, ASP, vbscript) without using the Application
> that is intended to do it. Could someone point me in the
> right direction on enabling this on SQL, or recommend a
> product.
> Thanks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment