Cannot find the object 'sp_positivepay', because it does not exist or you do not have permission.

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?
LVL 1
apitechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

apitechAuthor Commented:
Disregard....this is resolved.

Even though grant.sql was calling the stored procedure “sp_positivepay”, the name of it is actually “coastuser.sp_positivepay”.  In other words, it was going by a different namem even from what it was called in the sysobjects table!

Once I deleted that stored procedure, grant.sql ran just fine and within a millisecond at that!

The client said that it was OK to delete it, since it references an outdated positive pay procedure that they programmed in 2002.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.