Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Other than through a custom interface to store/fetch files using the old filestream way, is there a way to log which user modified a file opened directly from the share exposed by Sql Server 2012?

share|improve this question

migrated from stackoverflow.com Aug 10 '12 at 5:25

This question came from our site for professional and enthusiast programmers.

Turn on auditing at the file system level. The file system APIs should then capture this information to the Security Event log.

share|improve this answer

This is not possible without some type of file watcher application as Windows does not track this information itself.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.