asked on

MSSQL7 logs?

Hi,
i have mssqls7 on NT4 wiht SP6.
how can i see the activities of all users.
for example, how can i see who deleted/addd/updated a specific record?
help me!
thanks
NIMA

Guy Hengel [angelIII / a3]

You can't unless you have some triggers on the tables to save the information to extra tables, or you buy some logminer tools for reading the transaction log (backup).

CHeers

jchopde

You can set DBCC TRACEON(4032) to capture the receive buffer in the SQL Server log (usually only used when you are debugging something since it may flood your SQL Logs). DBCC TRACEOFF(4032) will turn this logging off. Trace flag 4032 captures the receive buffer only so it may not get as granular as you want it to be but it will at least tell you every SQL command by SPID.

aryumin

Take a look at http://www.lumigent.com/

ASKER CERTIFIED SOLUTION

gretzky_owns_u

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mohamadi

ASKER

gretzky_owns_u:

can you tell me more detail?
or simply send me an example...
thanks

jchopde

http://www.swynk.com/friends/sharma/profilerxp.asp

This link gives useful information for what gretzky_owns_u has suggested.

CleanupPing

Mohamadi:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.