Forum Replies Created

Viewing 15 posts - 496 through 510 (of 817 total)

  • RE: SQL mirroring failover and failback, re-assigning Primary DB

    If I'm understanding your question correctly:

    To set your primary instance back to being the PRINCIPAL, issue the following command:

    -- http://msdn.microsoft.com/en-us/library/bb522476(v=sql.100).aspx

    ALTER DATABASE [yourDatabase]

    SET PARTNER FAILOVER

    GO

    To change the timeout setting:

    ALTER DATABASE [yourDatabase]

    SET...

  • RE: DDL trigger

    The link takes you to the SQL Server 2012 entry, it just doesn't tell you that very well. Look on the left hand navigation hierarchy, it shows 'Books Online...

  • RE: Talking baseball

    Sounds a lot like a typical Giants game. I'd pinch run for Posey on first with Blanco (the speedy jack rabbit) and let Pill pinch hit for Huff. ...

  • RE: Question on WordPress Preferences

    1. I'm using the 'zBench' theme. I wish I could find one that I could make do what I want and not look like everyone else. And of...

  • RE: Dynamically build connect string for Maintenance Plan Task in SSIS

    Got it to accept the dynamic connection string using the above layout but didn't think past that. The Maintenance Plan tasks are asking for more than just a connection...

  • RE: Talking baseball

    Grats Steve, sounds like fun. Tell anyone who asks about the lip that you were in a bar fight and that they should see the other guy. Then...

  • RE: Talking baseball

    Markus (4/19/2012)


    I heard an interesting stat last night.

    Jamie Moyer pitching for the Rockies and got the win and with that win he became the oldest player ever to win a...

  • RE: Sequences I

    Thanks, learned something new.

  • RE: Deploy a data tier application

    Thanks Jerry. Indeed, I did not register the database first as a data tier application then try and upgrade it. I kept reading the same areas in BOL...

  • RE: Data and Log Space Alerts

    I snooze, I lose!

    I'm just glad it got written. Take all the feedback with an open mind, it'll only make you better in the long run.

  • RE: Talking baseball

    Giants start out 0-3, starting pitching gets rocked and the bats are talkin'....weird opening weekend for SF. At least the Yankees and Red Sox are in the same boat.

    Steve,...

  • RE: Talking baseball

    2 billion, yikes. One of the co-owners of the GS Warriors is in the ownership group for the Dodgers now.....WTF?!?!??

    Lincecum and Kershaw horsin' around doin' photo ops...

    $25 cheap tix...

  • RE: Database mirroring and index maintenance

    Good point Lynn, suspending the mirroring won't work.

    Back to the drawing board.

  • RE: Talking baseball

    Traditionally I always disliked the DH and the style of baseball it promotes. But I've always been frustrated with a pitcher's lack of ability at the plate and the...

  • RE: Talking baseball

    I didn't get a chance to listen to any games this weekend (SQL Saturday in Mountain View was a blast) but am excited for baseball on the radio again.

    Here's to...

Viewing 15 posts - 496 through 510 (of 817 total)