Forum Replies Created

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

  • RE: Are the posted questions getting worse?

    ThomasRushton (6/10/2016)


    Ed Wagner (6/10/2016)


    Brandie Tarvin (6/10/2016)


    Wait. Are you talking about you or the OP?

    I thought you were talking about the OP.

    I thought so too. They can be a little...

    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?

    ThomasRushton (6/10/2016)


    Brandie Tarvin (6/10/2016)


    ThomasRushton (6/10/2016)


    Am I being unreasonable in now thinking "perhaps you're not the one who should be doing this"?

    I'm going to say Yes only because DB Mail is...

    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?

    ThomasRushton (6/10/2016)


    Am I being unreasonable in now thinking "perhaps you're not the one who should be doing this"?

    I'm going to say Yes only because DB Mail is incredibly confusing 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: how can i install and configure smtp server/services

    naveenareddy.dba (6/9/2016)


    Hi

    i tried this but its giving the error like this

    Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62

    The configuration option 'Database Mail XPs' does not exist, or it...

    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: how can i install and configure smtp server/services

    naveenareddy.dba (6/10/2016)


    Hi

    yes it is the sql server 2012.

    i have done all the things still mail is not sending the status is failed its saying.

    i uploaded the screen... please suggest 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?

    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.

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