Forum Replies Created

Viewing 15 posts - 3,121 through 3,135 (of 9,720 total)

  • RE: Manually failing over a mirror without access to Primary Server

    Perry Whittle (8/21/2014)


    arnipetursson (8/21/2014)


    One more question.

    If you do not have access to server B beyond db_owner in the database,

    how do you ensure that the logins (server principals) are synced?

    Curious, how...

    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: Manually failing over a mirror without access to Primary Server

    happycat59 (8/21/2014)


    arnipetursson (8/21/2014)


    One more question.

    If you do not have access to server B beyond db_owner in the database,

    how do you ensure that the logins (server principals) are synced?

    As db_owner, you...

    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: Compare two columns<!-- 864 -->

    Myke85 (8/21/2014)


    How I can get 'good'?

    DECLARE @Email VARCHAR(100)

    DECLARE @Email2 VARCHAR(100)

    Set @email= 'helper@sql-server-helper.com'

    set @email2='fff@dd.com, helper@sql-server-helper.com,vc@.com'

    SELECT case when @email like...

    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: Manually failing over a mirror without access to Primary Server<!-- 864 -->

    And that's what happens when I forget how to read a post all the way through. @=)

    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: Manually failing over a mirror without access to Primary Server<!-- 864 -->

    On another note, I recently found that I can also just break the mirror from either the primary or the secondary as per this BOL note. So it all depends...

    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: Today's Random Word!<!-- 864 -->

    Ed Wagner (8/21/2014)


    whereisSQL? (8/21/2014)


    EL Jerry (8/21/2014)


    jasona.work (8/21/2014)


    crookj (8/21/2014)


    Ed Wagner (8/21/2014)


    TomThomson (8/21/2014)


    Brandie Tarvin (8/20/2014)


    Ed Wagner (8/20/2014)


    Bug

    Snafu

    Government IT

    Expensive

    Amateur

    Night :hehe:

    Sleep

    Coffee

    Espresso 😀

    Bean

    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: SQL Server US Contracting Rates<!-- 864 -->

    MMartin1 (8/20/2014)


    This applies to things like buying a car as well. Good luck.

    Except when buying a car, I have no intention of offering the highest possible price first. @=)

    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: Today's Random Word!<!-- 864 -->

    Ed Wagner (8/20/2014)


    Bug

    Snafu

    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: Today's Random Word!<!-- 864 -->

    Sean Lange (8/20/2014)


    Cool. I was trying to find his email address since I didn't see him on any thread recently. I was going to find him on linkedin or twitter...

    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: SQL Server US Contracting Rates

    Look at Salary.com for ranges that are dependent on job description and location. Then figure out how comfortable you are with prices in that range.

    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: Sleeping Log Reader Agent blocking Distribution clean up job

    Are you not replicating index changes over to the subscriber?

    Let us know if your fix doesn't fix and we'll take it from there.

    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: Manually failing over a mirror without access to Primary Server

    Thanks, Perry. I appreciate the assist.

    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 to Check SQl Driver for MS ACCESS

    Check your connection strings (scroll down to find 2007 and on) compared to this document[/url].

    Have you verified the drivers on your pc and the server via the method I mentioned...

    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: Compare two columns

    My problem is that he still hasn't explained in English what he expects the result to be. I told him specifically NOT to explain it in code and that's what...

    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: SQL Server US Contracting Rates

    lptech (8/18/2014)


    Try looking on Indeed.com or Dice.com and see what rates companies are offering in their postings in your target area.

    Usually those companies' websites lead back to salary.com for 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 - 3,121 through 3,135 (of 9,720 total)