I am trying to use a proc to get a file via fta for a sql server login. It does work when in sa server role, however does not work when I remove from sa, give read and write as well as xp_cmdshell exec righs. Any ideas?
Use 'SET XACT_ABORT ON' in the PROCEDURE CODE. Hope this helps!!!
The_SQL_DBA MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply