• Wow. I nicely written, intelligent, grammatically correct (99% anyway) article that I could follow step by step with clear instructions to guide me through a useful learning process. I'm impressed. Nice one Mr. Kelley. I've been using Profiler for years and know that it is a great tool for this type of security auditing. One thing about SQL Profile is that, instead of requiring users to be in the sysadmin role in order to use the tool, you should be able to dole out permissions to non-sysadmin users. I've seen plenty of cases where good sql developers, who we did not want to give sysadmin role to on security-tight servers, could have used the tool without abusing it if we could have given them permissions. Is this possible?

    -Vic