Database Log

Question

Database Log

Nita Reddy

SSCarpal Tunnel

Points: 4182
More actions
December 1, 2005 at 11:12 am

#167194

Can anyone tell me how to keep log of Users running any query against DB.
In other word how to keep track log of what user is running.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gagandeep Singh SSCommitted Points: 1513 More actions · Answer 1

The only way to see what is the SQL that user is running on SQL Server 2000 is to run SQL Server Profiler, assuming that the stored procedures or SQL Statements comming from the database are not encrypted.

Nita Reddy SSCarpal Tunnel Points: 4182 More actions · Answer 2

So I need to create SQL profiler, and yes sp's are not encrypted.

WE have very small DB...and there are only 2 users (developers) running SQL query and Running some reports out of this, I just want to keep log of what they doing because this a HR application.

Just want to keep track of users of they are not going to check anyone's personal information.

Thanks

Nita

Jason Hall Hall of Fame Points: 3906 More actions · Answer 3

If you don't want these users checking personal information the best thing to do would be to deny select permissions on those sensitive tables from the users. You are better off making sure that they do not view the information than disciplining them after it happens.

If you cannot revoke permissions than you could monitor this by running a profiler trace. Be cautioned however that running a profiler trace will impose a fairly significant CPU load on your server.