Cannot Modify tables after Replication Switched off

If you run:
select replinfo from sysobjects
where name = 'yourtablename'
What comes back? If there is a 1, then update it to 0. If
it's not a 1 then I'll have a rethink!
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
"Adrian320" wrote:

> What if the number in sysobjects is 3 instead of 1, no problem?
> If I get the error message that ad hoc updates to sysobjects is not
> configured, how do I change that parameter.
> Thanks.
In Enterprise manager: Check "Allow modifications to be made directly to the
system catalogs" under Tools ->SQL Server Configuration Properties ->Server
Settings.
|||What if the number in sysobjects is 3 instead of 1, no problem?
If I get the error message that ad hoc updates to sysobjects is not
configured, how do I change that parameter.
Thanks.
"Paul Ibison" wrote:

> If you run:
> select replinfo from sysobjects
> where name = 'yourtablename'
> What comes back? If there is a 1, then update it to 0. If
> it's not a 1 then I'll have a rethink!
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>