• Jeff Moden (8/15/2008)


    I'm such a dummy... to do this in almost a single click, I just need to turn of the SQL Server Agent and turn it back on when I'm done. Thanks anyway, folks.

    Hi Jeff,

    Sorry to dig up an old thread, I am looking to disable (not drop) on an 2005 instance where dbs are going to migrated from. I only want to disable since if migration fails and we need to backout and turn the replication back on, can you simply stop the SQL Agent? (This wil be stop anyway.)

    Thanks

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]