CODEWITHSUNDEEP
sharepointsql-server-2008
user384080
user384080

Reputation: 4692

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_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

Answers (1)

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17373

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

Upvotes: 1

Related Questions