Replication Expired subscription clean up job failed

Don't know why this job failed since I deleted and rebuilt the subscriber and
publisher last week. Can someone help?
Error detail says: 'Executed as user: FOSTER\sqlservice. Could not find
stored procedure ''. [SQLSTATE 42000] (Error 2812) Associated statement is
not prepared [SQLSTATE HY007] (Error 0). The step failed.'
Appreciate your time.
Tsuey
Tsuey,
please take a look at this to see if it applies:
http://support.microsoft.com/kb/884854
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
Thanks for the quick reply. I read this article and don't think it apply.
I don't think I created the replication as transactional replication with
queued updating. If I did, SQL Server will add a new column in each
replicated table, right? How can I sure that the replication is not
configured as queued update?
Tsuey
"Paul Ibison" wrote:

> Tsuey,
> please take a look at this to see if it applies:
> http://support.microsoft.com/kb/884854
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Tsuey,
what is the 'update mode' if you run sp_helpsubscription?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul, I tried to execute sp_helpsubscription in Query analyzer (hope this
is the right tool to run it) but how do I display the result set? I set the
result in grid or text or file, but can not get the result set to display.
It just simply tells me 'The command(s) completed successfully'. What did I
do wrong? The syntax I use is as below:
exec sp_helpsubscription
GO
"Paul Ibison" wrote:

> Tsuey,
> what is the 'update mode' if you run sp_helpsubscription?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||You'll need to execute this at the publisher on the publication database and
provide the subscriber name.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul, I got the sp_helpsubscription ran successfully!! The update mode
for all rows are 0's. It means 'read-only'. What does this tell me? FYI,
we configure the replication as a push replication.
Thanks for your time,
Tsuey
"Paul Ibison" wrote:

> You'll need to execute this at the publisher on the publication database and
> provide the subscriber name.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||OK - then the article definitely doesn't apply. I'd be tempted to reapply
your latest service pack on the distributor, publisher then subscriber. If
that doesn't resolve this issue they I'd raise a support case.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
Thanks very much for your reply. I'll try appying the SP4 to see if it helps.
Tsuey
"Paul Ibison" wrote:

> OK - then the article definitely doesn't apply. I'd be tempted to reapply
> your latest service pack on the distributor, publisher then subscriber. If
> that doesn't resolve this issue they I'd raise a support case.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>

Replication error after installing SP3a

After installation of SP3a on the publication server, clients are getting
errors during replication.
The error detail is : "Select permission denied on object
'MSDistributor_access', database 'tempdb', owner dbo
does this table exist in tempdb?
"Nol Thoelen" <noel.thoelen@.itomni.be> wrote in message
news:407bdf20$0$876$a0ced6e1@.news.skynet.be...
> After installation of SP3a on the publication server, clients are getting
> errors during replication.
> The error detail is : "Select permission denied on object
> 'MSDistributor_access', database 'tempdb', owner dbo
>
>
|||Yes, the table does exist in the tempdb database
"Hilary Cotter" <hilaryk@.att.net> schreef in bericht
news:erRWAPXIEHA.2596@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> does this table exist in tempdb?
> "Nol Thoelen" <noel.thoelen@.itomni.be> wrote in message
> news:407bdf20$0$876$a0ced6e1@.news.skynet.be...
getting
>

Replication

Dear Professional,
I am encountering one error while the data is going to be replicated.
Here is the detail !
Last Command :
{CALL sp_MSins_Master (16, 'Okie', 1,
{5575376A-73CB-419C-9175-F6662FB115B7})}
Transaction sequence number and command ID of last execution batch are
0x0000000B00000197000400000000 and 1.
Error message :
Could not find stored procedure 'sp_MSins_Master'.
Error Detail:
Could not find stored procedure 'sp_MSins_Master'.
(Source: NOOR\NOOR (Data source); Error number: 2812)
What I have to do for resolving the stored procedure 'sp_MSins_Master'.
Thanks in advance.
The procedure 'sp_MSins_Master' needs to exist in the subscribing database,
for replication to apply the insert statements. If this proc is lost for
some reason, then you can recreate it by runnning
sp_scriptpublicationcustomprocs on the publishing database, copying and
running the output script on the subscribing database.
Note that you only need to run the script for missing stored procedures. See
BOL for more info.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"John" <naissani@.hotmail.com> wrote in message
news:u5nhUo8EFHA.1296@.TK2MSFTNGP10.phx.gbl...
Dear Professional,
I am encountering one error while the data is going to be replicated.
Here is the detail !
Last Command :
{CALL sp_MSins_Master (16, 'Okie', 1,
{5575376A-73CB-419C-9175-F6662FB115B7})}
Transaction sequence number and command ID of last execution batch are
0x0000000B00000197000400000000 and 1.
Error message :
Could not find stored procedure 'sp_MSins_Master'.
Error Detail:
Could not find stored procedure 'sp_MSins_Master'.
(Source: NOOR\NOOR (Data source); Error number: 2812)
What I have to do for resolving the stored procedure 'sp_MSins_Master'.
Thanks in advance.

replication

hey anybody knows where i will get detail information on
SQLServer 2000 Replication?
i want to go through all replication types?
Please let me know
thanks and regards
hrishikeshCheck
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"hrishikesh" <musaleh@.mahindrabt.com> wrote in message
news:094901c36df2$58d6c810$a301280a@.phx.gbl...
> hey anybody knows where i will get detail information on
> SQLServer 2000 Replication?
> i want to go through all replication types?
> Please let me know
> thanks and regards
> hrishikesh
>