Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
Scripts to Reset System and Budget Passwords
November 5th, 2014 by
To run this script change the highlighted section to the name of the budget which needs the password reset:
UPDATE GL00200 SET BUDPWRD = 0x00202020202020202020202020202020 WHERE BUDGETID = 'budget id' GO
A very similar script can be used to reset the System Password. If you are using a Named System Database, change the highlighted DYNAMICS text to the name of your System Database:
USE DYNAMICS GO UPDATE SY02400 SET Password = 0X00202020202020202020202020202020 GO