Output as CSV file.

• BBSR

  SSCommitted

  Points: 1921

  More actions

  February 17, 2012 at 8:23 am

  #1448553

  thank you Jeff. that will be a good idea. will dump the records in a table

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  February 17, 2012 at 11:24 am

  #1448688

  Jeff Moden (2/17/2012)

  ---

  Revenant (2/16/2012)

  ---

  Jeff Moden (2/16/2012)

  ---

  Revenant (2/16/2012)

  ---

  - calling the shell is generally considered unsafe; and

  I absolutely agree but only because most people don't take the time to set up for its use properly. It can, in fact, be done very safely.

  Absolutely correct, Jeff, but that is how the cookie (usually) crumbles.

  So help me out here a bit. Instead of saying something like it's "generally considered unsafe", explain why instead of just falling in line with a bunch of people that don't know how to implement it correctly. xp_CmdShell can be setup so that it's perfectly safe. What's MUCH more dangerous are apps that have any more than PUBLIC privs on the database.

  Agaiun, I agree with you, Jeff. I am trying to stick with the topic and just note that there is some unmentioned facet of the issue. However, I take your suggestion and next time I will get into more detail.

• Jeff Moden

  SSC Guru

  Points: 1000539

  More actions

  February 18, 2012 at 10:00 am

  #1448911

  Ah... ok. Now I get where you're coming from. Thanks for the consideration.

  --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)
  Intro to Tally Tables and Functions