SQL Server Performance

Disabling repl error

Discussion in 'SQL Server 2005 Replication' started by xiebo2010cx, Feb 1, 2007.

  1. xiebo2010cx Member

    one week ago, for testing purpose, I set up trans repl, trans repl with updateable, snapshot repl using the same instance.<br /><br />configuration is like this,<br /><br />publisher and distributor are on the same server, 2 remote subscribers, one is 2000, the other is 2005.<br /><br />It works OK, today I am trying to disable the replicaiton, clean up the machine. keep getting the errors:<br /><br /> an exception occurred while executing a T-SQL statement or batch<br /> only replicaiton jobs,or job schedules can be added, modified,dropped or viewed through replicaiton SPs<br /> could not update the distribution database subscription table, the subscription status could not be changed.<br /> changed database context to 'master',(MSSQL SERVER error 2253<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br /><br /><br />Please help<br /><br /> <br /><br /><br />------------------<br />Bug explorer/finder/seeker/locator<br />------------------
  2. xiebo2010cx Member

    publisher: 2005 Standard SP2 CTP

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  3. MohammedU New Member

    Why you want to still keep CTP?

    MohammedU.
    Moderator
    SQL-Server-Performance.com
  4. xiebo2010cx Member

    Test server, testing for SP2 enhancement


    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  5. MohammedU New Member

    Got it...<br />Sorry! I misread... it is SP2 CTP not SQL 2005 CTP<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com
  6. xiebo2010cx Member

    You got it? MohammedU, then what do you think...........

    I am guessing it is because of the linked server settings. Searched a lot of places, could not find something valuable.

    one things may give you guys clues, for the Trans Repl with updateable subscribers, I could not be able to update the subscribers because of the linked server setting, I just guess

    see this link, may related..
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=274139&SiteID=1



    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  7. MohammedU New Member

    May be your right... relate to Linked server ...
    Did you try running linked server query between the publisher and subscriber?
    Try removing replication manually using procedures...


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  8. satya Moderator

    Do you get the same on a SQL 2005 SP1 setup?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  9. xiebo2010cx Member

    To Satya, sorry, I only did this on SP2 CTP, don't know will this happen to SP1.

    To Mohammed, I tested all the linked servers, it seems work. will try using sps.

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  10. xiebo2010cx Member

Share This Page