Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 9,715 total)

  • RE: Who Watches the Watchers?

    Talk about article timing. Have any of you seen this?

    http://arstechnica.com/security/2014/09/home-depots-former-security-architect-had-history-of-techno-sabotage/%5B/url%5D

    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: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    BAH! All the settings are the same between both servers. Pics attached.

    I'm beginning to think I'm fighting a losing battle here and might have to go with just selecting data...

    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: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    Lynn Pettis (9/19/2014)


    Compare the MSDTC settings between two working systems (one being the one you are trying to run the procedure from) and between the two systems that aren't working....

    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: Where Did The Women Go?

    Thanks for that link, Paul. It's an interesting article with a very good point.

    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: Where Did The Women Go?

    Ah. I assumed you were in a U.S. company. My bad.

    I understand the strange working hours better now, though. I assume most of the companies you do work for are...

    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: Divide by Zero frustration

    ashok_k_ghattamaneni (9/22/2014)


    I tried this approach. it ddn't work for me. please help me..

    Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double)

    If IsNothing(Divisor) Or Divisor = 0

    Return...

    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: Where Did The Women Go?

    Just because the men volunteer work the odd shifts, doesn't mean their bodies aren't reacting to the stress. It just means they're ignoring it. It's also the product of an...

    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: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    Shawn Melton (9/19/2014)


    Brandie Tarvin (9/19/2014)


    Shawn Melton (9/17/2014)


    Grant execute explicitly to that procedure for the login being used.

    Odd that granting EXECUTE on the entire schema in Master didn't work, but explicitly...

    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: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    Brandie Tarvin (9/19/2014)


    Shawn Melton (9/17/2014)


    Grant execute explicitly to that procedure for the login being used.

    Odd that granting EXECUTE on the entire schema in Master didn't work, but explicitly granting 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: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    Shawn Melton (9/17/2014)


    Grant execute explicitly to that procedure for the login being used.

    Odd that granting EXECUTE on the entire schema in Master didn't work, but explicitly granting that proc did.

    Thanks,...

    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: Analysis Services fails to start after master database rebuild/restore

    As long as you have the install files, there's always a way to run repair.

    Unfortunately, you're not giving much detail that enables anyone to assist. I know you say 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: Execute Permission denied on xp_sqlagent_enum_jobs between databases

    Shawn Melton (9/17/2014)


    What query are your trying to execute to get job status?

    [linkedserver].master.dbo.xp_sqlagent_enum_jobs

    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: Backups failing with ACCESS DENIED

    Excellent.

    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: Transactional Replication Report

    This sounds like a job for SSIS!

    @=)

    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: Analysis Services fails to start after master database rebuild/restore

    Did you check the Event Viewer or just the SQL logs?

    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 - 3,076 through 3,090 (of 9,715 total)