I suggest you to use EVENT NOTIFICATIONS instead. Check out my following article in which I discussed the several ways to audit securty:
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
- Proposed as answer by vr.babu Wednesday, September 12, 2012 10:15 AM
try if this works, you can directly fire queries instead of importing them to a database, check this lick
Ramesh Babu Vavilla MCTS,MSBI
- Marked as answer by Shulei ChenModerator Wednesday, September 19, 2012 8:22 AM