How To Reset MS Dynamics GP System Password

UPDATE DYNAMICS..SY02400 SET DMYPWDID=1,PASSWORD = 0x00202020202020202020202020202020

Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'run'.

while running that script "run DBCC CHECKDB" i got the above error to solve it create the following stored procedure and re-run the script again.




CREATE PROCEDURE run

AS

SELECT * FROM SYS.tables

An inconsistency was detected during an internal operation in database 'tempdb'

Also if you lost the "Tempdb" tables, all what you have to do is restart the SQL server as the Tempdb" tables created each time you restarting the SQL server.