xp_cmdshell issues

  • IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.

    http://www.sommarskog.se/grantperm.html

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

  • Jeff Moden (12/3/2014)


    IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.

    http://www.sommarskog.se/grantperm.html

    Hi Jeff,

    In my first post on this topic i provided this link :hehe:

  • Emil Bialobrzeski (12/4/2014)


    Jeff Moden (12/3/2014)


    IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.

    http://www.sommarskog.se/grantperm.html

    Hi Jeff,

    In my first post on this topic i provided this link :hehe:

    Thanks, Emil... I missed that big time.

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

  • One more question:

    Let's assume I go with the certificate method.

    Each night, we do database transfers to various target servers, using smo.Transfer.

    Does the certificate/permissions granted by the cert travel w/ the DB?

    P

  • schleep (12/12/2014)


    One more question:

    Let's assume I go with the certificate method.

    Each night, we do database transfers to various target servers, using smo.Transfer.

    Does the certificate/permissions granted by the cert travel w/ the DB?

    P

    Sorry for the late reply. I have no idea when it comes to the certificate method because I don't personally use it.

    --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 5 posts - 16 through 19 (of 19 total)

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