Notifications
Announcements
No record found.
Does anyone recognize this prefix? sp_MSupd_
I was in SSMS looking up stored procedures and discovered that every stored procedure in GP has a matching one of these. They were created back in the spring of 2004. This client was originally Btrieve and then migrated to MS SQL. Could these be left over stored procedures from that migration?
Hi Richard,
I am not familiar with that prefix and am not finding anything internally to lend direction. However, my assumption is you are likely on the right track that they are from a far prior version and/or were unique to the upgrade process in prior versions of Dynamics GP. Hopefully the user community can offer more insight as well.
Best Regards,
Jeff
Richard,
A quick search returned some interesting links.. .my assumption is that this isn't even related to GP itself, but rather some SQL processes for data replication that had been in place once back in time..
sqltimes.wordpress.com/.../
support.microsoft.com/.../kb2931001-fix-distribution-agent-skips-applying-sp-msins-sp-msupd-sp-msdel-stored-procedures-on-a-subscriber-that-is-initialized-with-backup-in-sql-server-2012-or-sql-server-2014-f61ebb72-5f23-6bd3-cfc5-be85c8a2d9bd
It looks like some Transactional Data Replication might have been setup way back from another system..
Hi, this is very familiar to me, if you see stuff along the lines of the following, then this is artefacts of SQL replication objects.
That database is, or was involved in SQL replication. Be careful you don't mess up the replication if its still active
These SQL objects are used to control the replication of objects to other servers/databases.
Check the replication node in SQL server as first stop, right click on the "Replication" node for replication monitor etc to see what is set up now.
Bingo, that is what they had me try back in 2004. It was never used just tried, I will clean these up.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 544 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
