Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    Y.B. (6/9/2016)


    So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

    I realize that there are good...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/8/2016)


    Lynn Pettis (6/8/2016)


    Mention Dynamic SQL and suddenly that is THE solution for the immediate problem, but what problems may it cause down the road?

    Won't be surprised if we...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Non sysadmins have been denied permission Error on job that previously worked

    Ahha! A clue.

    The SQL Server Agent Service is running under an application domain account instead of our usual SQL Server Agent Service account for some reason. So I am now...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    <headdesk>

    User asks me to move this bit of code into QA:

    ALTER TABLE MyTable

    ADD Col1 INT,

    Col2 INT

    GO

    I push back and say "Please add your statement terminator" because...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Non sysadmins have been denied permission Error on job that previously worked

    Eric M Russell (6/8/2016)


    In MSDB, the following database level roles grant members various levels of permission to do things like monitor or start jobs.

    SQLAgentUserRole

    SQLAgentReaderRole

    SQLAgentOperatorRole

    https://msdn.microsoft.com/en-us/library/ms188283(v=sql.110).aspx

    The testers already had those...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    HAPPY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    VS 2012 Update 5 fixed my crash problem.

    HAPPY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    :hehe:

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Ray K (6/7/2016)


    Lynn Pettis (6/7/2016)


    Luis Cazares (6/7/2016)


    WayneS (6/6/2016)


    PRO TIP:

    If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    WayneS (6/6/2016)


    PRO TIP:

    If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.

    Which is why we...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/6/2016)


    I need the assistance of someone well-versed in SQL Server internals who might be able to explain why SQL is behaving oddly. I'd actually like an explanation of...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Can anyone explain a weird failover issue?

    GAH! Nevermind. Figured it out.

    Of all the freakin' ridiculous things to do, I set the server name in the aliases as the virtual clustered server name (SvrA) instead of the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    I need the assistance of someone well-versed in SQL Server internals who might be able to explain why SQL is behaving oddly. I'd actually like an explanation of why this...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (6/3/2016)


    Brandie Tarvin (6/3/2016)


    Hugo Kornelis (6/1/2016)


    Lynn Pettis (6/1/2016)


    Just looking at the diagrams here does anyone else think a few of them may be wrong? It could just be...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (6/1/2016)


    SSMS is decoupled from SQL. You need to install that separately.

    Wait. Client tools are no longer an option to install with the rest of SQL...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (6/1/2016)


    Lynn Pettis (6/1/2016)


    Just looking at the diagrams here does anyone else think a few of them may be wrong? It could just be me, but I need...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/1/2016)


    Just looking at the diagrams here does anyone else think a few of them may be wrong? It could just be me, but I need to do...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 1,666 through 1,680 (of 9,720 total)