course you have to have the trace running. If you want to do this, set this up in a stored procedure, mark as a startup procedure, and then monitor and archive or delete this information over time. Probably need some weekly job to do this.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com