September 10, 2008 at 2:10 pm
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 ¤
September 10, 2008 at 7:14 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy