Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-01-07 : 13:53:04
|
| Hi,We are creating a procedure that will use xm_cmdshell and bcp out data from tables. everything is working fine but is there any way that xp_cmdshell/bcp works without setting up the proxy account as:xp_sqlagent_proxy_account N'SET' , N'company' , N'user' , N'password'otherwise password will be in cleartext in database and anytime user changes password we need to run this command again and againThanks--rubs |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-07 : 13:59:59
|
| Why do you need to use that account? Who will be running the stored procedure?Tara |
 |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-01-07 : 14:12:24
|
| user that will be running the procedure is just owner of database and don't have sysadmin rights and i believe to run bcp from xp_cmdshell i have to use proxy account--rubs |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-07 : 14:16:07
|
| Yes, if the account does not have sysadmin, then the other option is this proxy account. Why can't the user just run bcp.exe?Tara |
|
|
|
|
|
|
question on xp_sqlagent_proxy_account