FTP via LinkedServer not working

  • 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?

    ¤ §unshine ¤

  • 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