I've run to a problem in which I'm not sure where to look or how to fix it. The problem is the following. We have a site with a sql2000database. A backup from this was restored to create a development enviroment. Some of the store procedures are named [owner].name (owner is not dbo and I would want to keep the same structure in both live and development enviroment)
When I try to run those store procedures without specifing the owners name I get a "could not find store procedure" error. (using the owners credentials)
But I create a new user, and a new store procedure where this new users is the owner. And then login with the new user. Then I can find the store procedure by its name.
Owner = Daniel SPTest = store procedure (name Daniel.SPTest)
Login as Daniel, exec SPTest = store procedure not found <-- what is wrong here?
Create a new user and store procedure in the database Owner New User SPTest2 = Store procedure (name New User.SPTest2) Login as New User exec SPTest2 = runs procedure
I've tried to delete the user Daniel, then creating a new user with the username Daniel. But I still recieved the same error. Is there any other table where this kind of mapping is located?