sharepoint and sql server 2008 audit

I have activated the audit feature on wss_content database and alldocstream table but in the audit log does not show anything if the users access the file in the doc lib of sharepoint. However I tried to capture the sql statements while accessing the file in the doc lib and found that one of the stored proc is "proc_FetchDocForHttpGet". I executed this "proc_Fetch开发者_如何学编程DocForHttpGet" proc manually and managed to be captured in the audit log.

Does anyone know why none of activities in sharepoint is being captured by sql audit?

thanks

Isn't item-level auditing what you're looking for? It's a feature of SharePoint, not SQL Server.

• Item-Level Auditing with SharePoint Server 2007
• Document and list item auditing with SharePoint 2010