Forum Replies Created

Viewing 15 posts - 17,026 through 17,040 (of 59,067 total)

August 15, 2016 at 7:04 am

#1895439

  • RE: SQL 2012 Grant execute rights to user on specific SQL Agent Job

    joeroshan (8/15/2016)

    You can try adding execute as owner while creating the procedure, so that the user can impersonate your permissions.

    To run the job, probably.

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

    August 15, 2016 at 7:01 am

    #1895435

  • RE: How can restore deleted sql job

    I'll also add that the idea of source control for jobs and all other code on your server should become a concern... right after you get your backups setup so...

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

    August 15, 2016 at 6:47 am

    #1895423

  • RE: To Infinity and Beyond

    From the Article:

    The explosion in aircraft ...

    Now, there's two words that should never be so close together in a sentence. 😀

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

    August 15, 2016 at 6:42 am

    #1895419

  • RE: Bash for ETL pre-processing

    Heh... let's talk about "open minded"...Now all we have to do is get people over the fear of using xp_CmdShell and over the love affair with SSIS and you might...

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

    August 15, 2016 at 5:29 am

    #1895402

  • RE: Are the posted questions getting worse?

    ThomasRushton (8/15/2016)

    ChrisM@Work (8/15/2016)

    Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The...

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

    August 15, 2016 at 3:52 am

    #1895387

  • RE: power script to find backup status in sql server

    John Mitchell-245523 (8/15/2016)

    Jeff

    Does your job highlight just jobs that failed, or does it include those that didn't run, perhaps because they were accidentally disabled, or because SQL Server Agent wasn't...

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

    August 15, 2016 at 3:43 am

    #1895386

  • RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

    Sergiy (8/14/2016)

    sknox (8/14/2016)

    Sergiy (8/14/2016)

    There are other aspects which were not mentioned by anyone.

    1. The same small query populating a temp table may be reused in several procedures.

    In such case its...

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

    August 15, 2016 at 3:29 am

    #1895385

    • Viewing 15 posts - 17,026 through 17,040 (of 59,067 total)