Good Day i would highly appreciate if i could get some advise on how to see which user has run which scripts on the SQl database. i have multiple users connecting to a server and there is some users with write access. i need to trace the user and what last scripts they have run, as incorrect script has been run and created errors Can you please advise
Welcome to the forums. This is an expensive process to find out and if you want to restrict the permissions then you should control the security by letting them with proper fixed database roles, coming to the point you can take help of PROFILER trace to find the underlying events that are happening.http://msdn.microsoft.com/en-us/library/aa173918(SQL.80).aspx http://www.sql-server-performance.c..._Performance_Monitor_and_SQL_Profiler_p1.aspx
