DIGIT-ARC read-only archive · snapshot: July 23, 2026

Knowing Who changed data in MS SQL SERVEr

2 posts · originally from https://geek.digit.in/community/threads/knowing-who-changed-data-in-ms-sql-server.31079/

R
rajesh_nk22 Original post #1
Jun 30, 2006 at 8:53 AM
hi,

I want to know is there anyway by which we know who has changed or inserted data in a table.

Is this information stored anywhere.

I have a table salaraydata in my payroll application, this appplication is accessed using different people with different user names(SQL Server User/login Names).

Waiting for ur replies...

thanx
mediator
Jun 30, 2006 at 12:00 PM
Setup triggers!