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?
Bingo, that is what they had me try back in 2004. It was never used just tried, I will clean these up.
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.
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..
It looks like some Transactional Data Replication might have been setup way back from another system..
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
#1
André Arnaud de Cal...
292,978
Super User 2025 Season 1
#2
Martin Dráb
231,821
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
