Friday, February 10, 2012

Cannot find stored proc dbo.sp_MSmakeexpandproc

This question has to do with SL Server replication with CRM
I moved the CRM SQL Server mdf & ldf files from the C drive to the E drive
following the instructions in KB872585.
Everything went well except I cannot enable replication.
I performed the following steps:
Reopen Microsoft SQL Enterprise Manager; click Start, point to All Programs,
point to Microsoft SQL Server, and then click Enterprise Manager.
Expand Microsoft SQL Servers, expand SQL Server Group, expand your Microsoft
CRM SQL Server, then expand Replication Monitor, expand Publishers, and
expand your SQL Server Name where you will find the CRMMetaPub and CRMPub
publications.
Select CRMMetaPub and right-click the Snapshot in the right window pane.
Click Start Agent. (When finished the CRMMetaPub snapshot states, "A
snapshot of 79 article(s) was generated." )
Select CRMPub and right-click the Snapshot in the right window pane. Click
Start Agent.
This step fails with the error:
"Cannot find stored proc dbo.sp_MSmakeexpandproc."
When I search both drives for this file, I cannot find it.
I cannot find this error message in the knowledgebase.
Is this issue CRM specific or is it a general SQL Server replication
problem?
Can anyone tell me what is wrong? Right now our CRM is dead in the water.
Sounds like this proc is missing
I'm not sure why this is, but from time to time on this newsgroup and on one
site I have worked on the replication stored procedures go missing. The last
time this happened I think we were pretty sure that the service pack had not
been correctly applied.
Any way you can reapply the sp? Perhaps even SP4?
Hilary Cotter
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
"Dave" <dave@.nospam.ru> wrote in message
news:OsotUBNVFHA.3312@.TK2MSFTNGP09.phx.gbl...
> This question has to do with SL Server replication with CRM
> I moved the CRM SQL Server mdf & ldf files from the C drive to the E drive
> following the instructions in KB872585.
> Everything went well except I cannot enable replication.
> I performed the following steps:
> Reopen Microsoft SQL Enterprise Manager; click Start, point to All
Programs,
> point to Microsoft SQL Server, and then click Enterprise Manager.
> Expand Microsoft SQL Servers, expand SQL Server Group, expand your
Microsoft
> CRM SQL Server, then expand Replication Monitor, expand Publishers, and
> expand your SQL Server Name where you will find the CRMMetaPub and CRMPub
> publications.
> Select CRMMetaPub and right-click the Snapshot in the right window pane.
> Click Start Agent. (When finished the CRMMetaPub snapshot states, "A
> snapshot of 79 article(s) was generated." )
> Select CRMPub and right-click the Snapshot in the right window pane. Click
> Start Agent.
> This step fails with the error:
> "Cannot find stored proc dbo.sp_MSmakeexpandproc."
> When I search both drives for this file, I cannot find it.
> I cannot find this error message in the knowledgebase.
> Is this issue CRM specific or is it a general SQL Server replication
> problem?
> Can anyone tell me what is wrong? Right now our CRM is dead in the water.
>
>

No comments:

Post a Comment