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 |
|
SebJ
Starting Member
11 Posts |
 Posted - 2011-11-04 : 07:15:12
|
| Hey,I´m coming up with the following problem: I simply would like to generate a csv file and save my results in that. I´ve planned to do this using xp_cmdshell. I realized that I have to set this advanced option to 1 (default 0)...Now, my problem is that I don´t possess all the rights to use "Reconfigure" and stuff:EXECUTE permission denied on object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'. I´m at a loss... Are there any possibilities for me to get this right without annoying some instances above me in order to get these rights?!Thanks for any help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-04 : 07:43:17
|
| not sure you can as i think this permissions has to be GRANT ed to you explicitly by some admin ( as per above error message)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jassi.singh
Posting Yak Master
122 Posts |
Posted - 2011-11-04 : 08:22:15
|
| Hi,Refer this link:http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspxPlease mark answer as accepted if it helped you.Thanks,Jassi Singh |
|
|
|
|
|
|
xp_cmdshell