You’re offline. This is a read only version of the page.
50
Hello,
We have been trying to ascertain if 15,506 is a lot of stored procedures for a Dynamics GP database, it does seem like the installation has been through a few version upgrades, so could be from previous versions???
Is this normal? What is the average stored procedure count for a Dynamics GP database?
The application is running version 10.00.1193, using an SQL 2005 database.
Thanks in advance for any advice.
*This post is locked for comments
We have over 17,000 stored procedures in our GP2010 companies and we only use General Ledger and Accounts Payable. I am sure more modules would mean more procedures. Most SQL programming tools will list the procedures in alpha order. I use Rapid SQL. You can also see them in Microsoft SQL Server Management Studio that came as part of your Sql Server install. They are listed under Programmability under the database name.
I wonder if there is a list of those procedures somewhere available. I am looking for a certain procedure and was wondering how can I find it?
Hi Peter,
You're not that wrong :-)... Dynamics GP carries a lot of SP's and my GP2010 R2 has currently 32468 of them, from which I've added a couples myself. But as Richard said, upgrades usually take care of the clean-up, and even sometimes more (you've to re-install your own SP's and re-apply the security most of the time after an upgrade).
The amount of SP's has doubled since the GP10 (wich I remember had roughly 15k or so). I also realized that probably half the SP's are now protected by the system (i.e. you can't modify them), whereas I never had seen that before in GP10... I would have to grab back to an old VM copy of GP10 to make sure about this.
I have never counted them but I know there are thousands of them. Ugrades usually clean up old sp's.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (