Changing system table

• markwnorsoft

  SSC Eights!

  Points: 827

  More actions

  October 18, 2006 at 11:31 am

  #68449

  Hi,

  What I have is nt2003 sp1 and sql server 2005 sp1.

  I dropped a subsription and it did not clear the system table to say that the tables are no longer replicated tables. What I use to do on sql server 2000 is run this script.

  sp_configure 'allow updates', 1

  reconfigure with override

  update sysobjects set replinfo = 0 where name = 'tablename'

  sp_configure 'allow updates', 0

  reconfigure with overrid

  But when I run it now it tells me that I can't modify a system table. Is there a new way to modify the system tables?

  Thanks

  Mark

• Hari-353619

  Valued Member

  Points: 56

  More actions

  October 19, 2006 at 8:40 am

  #666817

  Mark,

  I would n't recommend modifying system tables . Seems like you are trying to modify in regards to replication which is again kinda flaky. Anyway

  Try running them separately.  Run them in following order: 

   1. sp_configure 'allow updates', 1

  then after above statement is successfully executed then run below  statement

    2.reconfigure  with override

  then

   3. update sysobjects set replinfo = 0 where name = 'tablename'

  finally execute the below statements separately

  sp_configure 'allow updates', 0

  reconfigure with override

  Let me know if you still have issues.

  THanks!!

  Hari