Notifications
Announcements
No record found.
Anyone knows why all these stored procedures would be missing? How do i get them back?
*This post is locked for comments
Even stranger is, the stored procedures exist on the Test Company, which is a copy of the live. But they do not exist in the live now.
Not sure why they would be missing, but you can re-create the dexterity procedures (those that begin with zDP_ ) by going into the SQL Maintenance window within Dynamics GP, and using the 'Drop Auto Procedures' and 'Create Auto Procedures' options for the database/module combination you want to re-create the procedures for.
In regards to the zDP_SY00500 procedure, you'd want to choose the 'Microsoft Dynamics GP' module for this company database.
Another option would be to script the procedure in SQL Server Mgmt Studio from the test company to a query window, then run the query window against the live company to create the missing procedure. (You'll need to remove the Use xxxx line from the top of the script, which will reference the database you generated the script from).
Thanks
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.
mtabor 1
