For Microsoft Dynamics GP on SQL 2005, I am conducting a test upgrade from GP 9.0 to 10.0.
Anyway, for this test upgrade, I followed the Microsoft KB article procedures on moving data from one server to another. So, I ran the grant.sql script against all GP company databases per those procedures. But, when I try to run the script against the DYNAMICS database, I get the following error message in SQL 2005 Management Studio:
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'sp_positivepay', because it does not exist or you do not have permission.
I cannot delete this stored procedure, in order to get rid of this error, as SQL does not show it as “being there”. Now, it is in the sysobjects table of the DYNAMICS database. But, how can I get rid of it so that I can run grant.sql?