Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Distribution database

    We often run into this in our QA environments. The below script is a blunt hammer approach to remove replication, no matter how fubared your server is:

    USE <yourreplicateddb>

    EXEC sp_removedbreplication...

  • RE: MsxEncryptChannelOptions and Multi-server administration

    I'm creating scripts for deployment, so it was simpler to use xp_regwrite:

    EXEC master..xp_regwrite

    @rootkey='HKEY_LOCAL_MACHINE',

    @key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\SQLServerAgent',

    ...

Viewing 2 posts - 1 through 2 (of 2 total)