I have a use case that requires a folder be created on the server for each record in the table...to which files will be uploaded under the EditForm.

I have created a stored proc using xp_create_subdir which of course works fine as long as I am testing the SP from the SQL server as a sysadmin.  There is a security concern letting non-admin SQL users have access to such functions.  I have researched this until I am blue in the face and have reach no reasonable answer.

Does anyone have a suggestion?  I just need to add the row to the table and create a subfolder on the server using the ID as the folder name.  

Just throwing this out to see if someone has run into a similar need.

Thanks,

Roy