• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

How can we place a file in a particular location on a server

How to execute bcp (which calls xp_cmdshell using the SQLAgentCmdExec id) from within a stored procedure and copy data into an Excel file on a file server?  Does SQLAgentCmdExec need rights to the location on the file server?
0
charmedimsure
Asked:
charmedimsure
1 Solution
 
ispalenyCommented:
SQLAgentCmdExec is a proxy for non-sysadmins. Sysadmins are accessing files by xp_cmdshell under SQL Server account, users under SQLAgentCmdExec account. So it depends on user, general user must have access thru  SQLAgentCmdExec account.  
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now