Running xp_cmdshell under non system admin

Question

Post reply

Running xp_cmdshell under non system admin

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 1

balbirsinghsodhi

SSCrazy Eights

Points: 9210

April 10, 2012 at 10:14 am

#1471318

Yes, I did all that.

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 2

I'll search for the error message when I get home but this is going to be a tough one to troubleshoot from here. I'm not sure there's anything I'll be able to do on this problem.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 3

balbirsinghsodhi

SSCrazy Eights

Points: 9210

April 10, 2012 at 10:02 pm

#1471662

No problem.. Thanks for your help.

newbie2 SSC-Addicted Points: 428 More actions · Answer 4

Hi Jeff, I'm having the same xp_cmdshell issues. By any chance can you post your script?

Thanks

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

newbie2 (1/4/2016)
Hi Jeff, I'm having the same xp_cmdshell issues. By any chance can you post your script?
Thanks

Check out http://www.sqlservercentral.com/Forums/Topic1160922-1550-7.aspx. Jeff posted his presentation he did at a SQL Saturday in Kalamazoo, MI. It explains each step. It was an excellent presentation.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 6

Ed Wagner (1/5/2016)
newbie2 (1/4/2016)
Hi Jeff, I'm having the same xp_cmdshell issues. By any chance can you post your script?
Thanks
Check out http://www.sqlservercentral.com/Forums/Topic1160922-1550-7.aspx. Jeff posted his presentation he did at a SQL Saturday in Kalamazoo, MI. It explains each step. It was an excellent presentation.

Thanks for the kudo, Ed.

The link Ed provided is for a page of the thread. The following is the exact post that Ed's talking about.

http://www.sqlservercentral.com/Forums/FindPost1707671.aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)