Output as CSV file.

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

  • 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.

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

Viewing 3 posts - 16 through 17 (of 17 total)

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