distribution agent error -- sql server replication

Jacx
7/19/2007 9:10:01 PM

Hi all,
I got this error in my distribution agent today it was

The process could not execute '{call sp_MSget_subscription_guid(25)}'

Can anebody tell me what caused the error and also what does the procedure
sp_MSget_subscription_guid actually do.

How can i avoid such errors in future.

Thanks in advance

Hilary Cotter
7/20/2007 6:40:01 AM

Can you run sp_lock on the subscriber database? See how many locks there
are.

Also enable logging as per this article and post the results back here.

http://support.microsoft.com/kb/312292

--
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
[quoted text, click to view]

sql server replication : distribution agent error