Post reply

Tx Replication

  • November 7, 2007 at 10:56 am

    #176747

    How can I delete sp_MS* SP's ?

  • November 8, 2007 at 5:42 am

    #749412

    Hi,

    Why?

    Thanks,

    Phillip Cox

  • November 8, 2007 at 8:56 am

    #749523

    Hi

    I was testing Tx replication from sql server 2005 to sql server 2000(push subscriber).

    Testing was successful. I referred this article http://support.microsoft.com/kb/324401 to remove replication. But I still see sp_MS* SP's in sql server 2000.

    Please let know if I am missing something here as I am new to replication.

  • November 8, 2007 at 2:05 pm

    #749643

    ent manager - left click on first - hold shift - clikc on last - press delete key.

    or - take output of this & exec in qa

    select 'delete proc ' + routine_name from information_schema.routines where routine_name like 'sp_MS%'

    ChrisB MCDBA

    MSSQLConsulting.com

    Chris Becker bcsdata.net

  • November 8, 2007 at 8:22 pm

    #749702

    Thanks Chris.

    Oh! I thought I was doing something wrong while removing the replication manually.

    But if u have 500 + tables EM doesnt sound to be good idea.

    Anyways thanks again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply