Finance | Project Operations, Human Resources, ...

Does anyone recognize this prefix? sp_MSupd

(0) Share

Report

Posted on by Richard Wheeler

75,730

Does anyone recognize this prefix? sp_MSupd

I was looking at a client's list of stored procedures and I noticed all of these. Every single GP stored procedure has one of these. They were created back in 2004.

I was thinking of removing them as none of the install products use this prefix.

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: Does anyone recognize this prefix? sp_MSupd

Derek, I bet someone tried to setup SQL replication back in 2004. Every table and every stored procedure has its own doppelganger.
Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Does anyone recognize this prefix? sp_MSupd

Looking in my GP 18.4 year end databases, I have no objects that begin with sp_msupd.... in my GP databases, but in the Master database, there are about 16 of them, even on SQL 2019:

sp_MSupdate_subscriber_info

sp_MSupdatelastsyncinfo

sp_MSupdatepeerlsn

sp_MSupdate_subscriber_schedule

sp_MSupdate_tracer_history

sp_MSupdatereplicastate

sp_MSupdaterecgen

sp_MSupdategenhistory

sp_MSupdate_subscription

sp_MSupdatesysmergearticles

sp_MSupdate_agenttype_default

sp_MSupdate_subscriber_tracer_history

sp_MSupdateinitiallightweightsubscription

sp_MSupdatecachedpeerlsn

sp_MSupdategenerations_afterbcp

sp_MSupdate_singlelogicalrecordmetadata

The first one appears related to SQL Replication Subscribers and Always On Availability groups.

The last one appears related to SQL Replication as well.

Based on this, I'd say, if you see these type of stored procedures in the GP databases, check to see if SQL Replication is currently and/or was configured on the databases.

Thanks