From: Sandeep on
We deleted the information of MSpeer_lsns from sysArtilces and
sysPublications tables but still getting same error.

Today morning futher investigation revealed that is_replicated column in
sys.tables catalog view still has value 1. Is there any way we can set this
flag to 0?



Select is_replicated from sys.Tables where name = 'MSpeer_lsns'



Thanks

Sandeep


"Sandeep" wrote:

> I cannot drop it using drop table MSpeer_lsns.
>
> Can I delete this table from sysArticles and sysPublications table.
>
>
>
>
>
> "Sandeep" wrote:
>
> > I Just noticed MSpeer_lsns is in sysArticles and sysSubscription table
> > although I don't see any publication and subscription
> >
> >
> > "Sandeep" wrote:
> >
> > > SQL Server 2005
> > >
> > > I am running this statement
> > >
> > > exec sp_replicationdboption @dbname = N'fxDb2', @optname = N'publish',
> > > @value = N'true',@ignore_Distributor = 1
> > >
> > > getting error
> > >
> > > Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 27
> > > Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for
> > > replication.
> > >
> > > I tried sp_removedbreplication @dbname = N'fxDb2'
> > >
> > > getting same error.
> > >
> > > Any help highly appreciated.
> > >
> > > Thanks
> > > Sandeep
> > >