Had to do a site shutdown this weekend and when the SQL server came back online it seems to have dropped theStoredProcedure:
smCleanupFilesBeforeLogin.
Users are getting this error when logging on to Dynamics GP10:
Stored Procedure smCleanupFilesBeforeLogin returned the following results: DBMS: XXX, Great Plains:XXX
This KB article has instructions on fixing the error we get http://support.microsoft.com/kb/849708
I've used Resolution 1 from this KB Article and downloaded the smCleanupFilesBeforeLogin script, but now the script reported that smAddPostingSecurityRecord is also missing. Trying to find it online atm, but so far nothing.
Can anyone help, please?
Thanks,
Trevor.
*This post is locked for comments