Auditing SQL?

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

Auditing a SQL user's Login activity

I have a database on my SQL 2000 server called Test. I have a SQL user accou
nt called Bob. I am trying to run a query against the Test database to see w
hen the last time Bob accessed the database. I did a google search and came
up with the following:
select UserName, LastLoggedIn = max(LoggedIn)
from {InsertYourTableName}
group by UserName
order by UserName
This seems to be at the Table level, not the database level. So then I tried
running SQL profiler, but before I waste too much time on Profiler, I was h
oping that someone could point in the right direction. Thanks.It appears that you would run the query after collecting the data using SQL
Profiler.
SQL Profiler can be configured to put the data it captures in a SQL table.
So, this sample code appears
to query the table.
This is not a query on the System tables. We don't capture this info by
default.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Audit User Activity

Hi All,

I'm an Oracle DBA that has inherited some SQL Server 2000 databases.
Can you audit a particular user in Sql Server 2000. We need to know exactly what a particular user is doing, (i.e. creating/dropping objects, and what data he is accessing)

what is the best way to do this??

Thanks,
DaveSQL Profiler (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_aa_2xiq.asp).

-PatP