Share
ReportAnyone knows why all these stored procedures would be missing? How do i get them back?
*This post is locked for comments
You’re offline. This is a read only version of the page.
Announcements
Anyone knows why all these stored procedures would be missing? How do i get them back?
*This post is locked for comments
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
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.
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
