Looking for Jeff Moden xp_cmdshell article

• Gabriel P

  SSCarpal Tunnel

  Points: 4289

  More actions

  October 25, 2012 at 8:19 am

  #393458

  I keep finding mentions of an article by Jeff Moden discussing 2-3 options on how to use xp_cmdshell safely, but I can't find the actual article itself. I feel like it should be an obvious find, but I'm having trouble finding it.

  He mentions he's writing it on this thread from about a year ago.

  http://beyondrelational.com/modules/1/justlearned/0/tips/8801/execute-bat-file-from-sql-server.aspx

• Jeff Moden

  SSC Guru

  Points: 1004646

  More actions

  October 25, 2012 at 10:49 am

  #1552809

  Gabriel P (10/25/2012)

  ---

  I keep finding mentions of an article by Jeff Moden discussing 2-3 options on how to use xp_cmdshell safely, but I can't find the actual article itself. I feel like it should be an obvious find, but I'm having trouble finding it.

  He mentions he's writing it on this thread from about a year ago.

  http://beyondrelational.com/modules/1/justlearned/0/tips/8801/execute-bat-file-from-sql-server.aspx

  I actually haven't written the article, yet.

  I can tell you that the first step to take is a lockdown of the server. No users or application logins can have SA privs anywhere on the server. Only authorized DBAs should have SA privs.

  --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)
  

• Gabriel P

  SSCarpal Tunnel

  Points: 4289

  More actions

  October 25, 2012 at 1:13 pm

  #1552899

  Thanks Jeff. I'll keep an eye out for it