Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 TRapping clients

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-11-04 : 07:12:23
shreemann narayana writes "hello
i want to trap the daily activities of all the clients.if i owned the profile it only show me the latest commands issued by all the clients.but i want to trp all the command issued by every client on daily basis how?
shreeman
if any body has some good solution which works:-i do not have service pack-3 of sql-server instaed i ahve service pack -2


mail me at sndshreman@redifmail.com or the given mail."

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2003-11-04 : 07:30:13
You can create a trigger to audit all inserts, updates, and deletes
Related reading - http://www.nigelrivett.net/AuditTrailTrigger.html
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-11-04 : 11:58:33
You could also purchase a third party product to do this. Just google "audit sql server" and you'll see a bunch of sites that have products like this.

Tara
Go to Top of Page
   

- Advertisement -