Hello All,
Go To Microsoft Dynamics GP --> Maintenance --> Clear data.
Now i manually clear the data, It is possible to clear the physical data through SQL. Stored
procedures. If any one knows please advice......
Thanks,
Pragadees
*This post is locked for comments
Now i understand.Thanks for your reply Leslie.......
Hi Pragadees,
The answer to your question is yes. Using SQL you can truncate any of the tables and clear the data. For the paticular table you have selected, trancating the table will not work for you. If you clear that table using the Clear Data window it actually populates the table with the Security Resource Descriptions. Truncating that table in SQL will not accomplish this task.
You could record a macro that stepped through the table clearing process, but I would check the macro after each SP or Upgrade to make sure it is still selecting the correct table.
Curiously, why do you want to use a stored proc?
Kind regards,
Leslie
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (