Dears,
I have either a service or even a user who keeps adding records to a certain table. Is there any way to know who added the records? Other than using the SQL Profiler.
Thanks,To collect statistical information about users, use either SQL Profiler or System Monitor (Windows NT Performance Monitor in Windows NT 4.0). Use the SQL Server Enterprise Manager Current Activity window to perform ad hoc monitoring of SQL Server, which allows you to determine user activity on the system.
Also, type this into the Books Online Search "Monitoring with SQL Server Enterprise Manager"
Also, is there a lock for the INSERT?
Hope it helps...|||Just add a column with as default User
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment