Reputation: 4692
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_FetchDocForHttpGet" 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
Upvotes: 0
Views: 376
Reputation: 17373
Isn't item-level auditing what you're looking for? It's a feature of SharePoint, not SQL Server.
Upvotes: 1