Re: How can I know who inserted a certain record??
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"