distribution agent error

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
Jacx
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
"Jacx" <Jacx@.discussions.microsoft.com> wrote in message
news:CEC339D5-E3A9-4369-B5D7-1B60854357CB@.microsoft.com...
> 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
> Jacx