Hello. I currently use SQL Profiler for our apps which we use to audit
security and events in seeing which SQL login user or Windows domain login
user did what on which database and what time, etc... An experienced
programmer recently mentioned that it's better to have 1 single Windows
connection to our SQL Server and do the auditing on the asp.net application
level instead. I was wondering if anyone knows of any tool or method that
comes with asp.net that can be used in seeing detailed user activity on the
data for security auditing like SQL Profiler does?
Thanks in advance.