Invalid Object name (208)

Hi,
I posted about this in late October, but the error 'went away' - it is now
back.
When I try and replicate, I get
Invalid object name 'dbo.sp_recreate_cybertill_tables'. (Source:
MSSQLServer, Error number: 208)
Hilary suggested
exec sp_droparticle 'Sleepwalker','sp_recreate_cybertill_tables'
but when I try this I get
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_droparticle, Line 102
This database is not enabled for publication.
This procedure doesn't exist when I try to select it from sys.objects.
Anyone got a clue?
Thanks
Pete
Shot in the dark...one of your other stored procedures, triggers, etc.
references this sp, which probably existed at some time. Script out the
entire database and search the script for 'sp_recreate_cybertill_tables'
Kevin3NF
SQL Server dude
http://kevin3nf.blogspot.com/
"Pete Vickers [MVP]" <pete at gui - innovations dot com> wrote in message
news:uZ6ZjxSUIHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I posted about this in late October, but the error 'went away' - it is now
> back.
> When I try and replicate, I get
> Invalid object name 'dbo.sp_recreate_cybertill_tables'. (Source:
> MSSQLServer, Error number: 208)
> Hilary suggested
> exec sp_droparticle 'Sleepwalker','sp_recreate_cybertill_tables'
> but when I try this I get
> Msg 14013, Level 16, State 1, Procedure sp_MSrepl_droparticle, Line 102
> This database is not enabled for publication.
> This procedure doesn't exist when I try to select it from sys.objects.
> Anyone got a clue?
> Thanks
> Pete
>
|||Hi Kevin,
thanks - I scripted and checked, and there is no reference to the procedure
thanks
Pete
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OF6uF4SUIHA.5132@.TK2MSFTNGP02.phx.gbl...
> Shot in the dark...one of your other stored procedures, triggers, etc.
> references this sp, which probably existed at some time. Script out the
> entire database and search the script for 'sp_recreate_cybertill_tables'
> --
> Kevin3NF
> SQL Server dude
> http://kevin3nf.blogspot.com/
>
> "Pete Vickers [MVP]" <pete at gui - innovations dot com> wrote in message
> news:uZ6ZjxSUIHA.5980@.TK2MSFTNGP04.phx.gbl...
>
|||The painful way is to add one article at a time until you find which one is
generating this error
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Pete Vickers [MVP]" <pete at gui - innovations dot com> wrote in message
news:%231SxbGTUIHA.1168@.TK2MSFTNGP02.phx.gbl...
> Hi Kevin,
> thanks - I scripted and checked, and there is no reference to the
> procedure
> thanks
> Pete
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OF6uF4SUIHA.5132@.TK2MSFTNGP02.phx.gbl...
>
|||Hi,
this is an already replicated database, which now errors after we added a
couple of articles, and we can't get past the error, so we now can't
replicate
Pete
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:uw7yXLTUIHA.4584@.TK2MSFTNGP03.phx.gbl...
> The painful way is to add one article at a time until you find which one
> is generating this error
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Pete Vickers [MVP]" <pete at gui - innovations dot com> wrote in message
> news:%231SxbGTUIHA.1168@.TK2MSFTNGP02.phx.gbl...
>
|||I take it the sp_recreate_cybertill_tables is a user proc?
If so you need to query sysarticles to find out if it exists. Do this in the
publication database and in the distribution database. You will need to
delete the enteries from there.
I urge you to backup your database before doing this as making modifications
to the system tables is not recommended.
You can contact me offline for more help.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pete Vickers [MVP]" <pete at gui - innovations dot com> wrote in message
news:uZ6ZjxSUIHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I posted about this in late October, but the error 'went away' - it is now
> back.
> When I try and replicate, I get
> Invalid object name 'dbo.sp_recreate_cybertill_tables'. (Source:
> MSSQLServer, Error number: 208)
> Hilary suggested
> exec sp_droparticle 'Sleepwalker','sp_recreate_cybertill_tables'
> but when I try this I get
> Msg 14013, Level 16, State 1, Procedure sp_MSrepl_droparticle, Line 102
> This database is not enabled for publication.
> This procedure doesn't exist when I try to select it from sys.objects.
> Anyone got a clue?
> Thanks
> Pete
>
sql