March 12, 2015 at 7:29 am
any assistance is appreciated, I have a SQL 2012 db, for my website, where users can upload documents, and the documents are stored in a file system on another server, and a record is entered into the database for it.
A developer is trying to write a function to verify that the uploads match the records, by checking the file size and other attributes of the file with what was entered into the database. He is using a batch script running as a windows scheduled task, and so the script needs SQL access, as well as file system access to the file, so a separate account with minimal permissions needs to be created and tested, etc and I don't think that's the best way to handle these types of functions.
Trouble is I don't necessarily know the best way to do it, should it use a sql job and an extended event, or powershell inside of SQL? Or some combination of them?
Any advice is greatly appreciated, thanks!
March 12, 2015 at 8:13 am
Are you using FileStream/FileTable? If not, why not? If so, SQL should be controlling the files.
Gerald Britton, Pluralsight courses
March 13, 2015 at 10:34 am
thanks for the reply, I'm not the SQL expert, just the network admin trying to keep a handle on permissions (both for SQL and file systems) and was hoping to find a better way to do whatever my developer is doing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply