Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Looking to ID sp prefix

editSubscribe (0) ShareShare
ReportReport
Posted on by 75,730

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?

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Looking to ID sp prefix

    Bingo, that is what they had me try back in 2004. It was never used just tried, I will clean these up.

  • Suggested answer
    Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: Looking to ID sp prefix

    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. 

    replication.png

    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. 

    Replication2.png

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,002 Super User on at
    RE: Looking to ID sp prefix

    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..

  • Jeff Grant Profile Picture
    Jeff Grant on at
    RE: Looking to ID sp prefix

    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans