I have a user (tn) that is dbowner on a database on a production site. This user owns nearly all the sprocs, tables and udfs in the database. We have backed up and restored this database from our production site to development and qa servers with no problems in the past (each server has the same SID for the tn user). Also, if we log into Query Analyzer (QA) as that user, we can execute any stored proc without specifying the owner (tn) explicitly and it works fine on the production site (EXEC usp_agenda_list, where the tn user owns this proc). Running Exec tn.usp_agenda_list works fine also.
We have a new server we have created the tn user with the same SID as everywhere else. We resoted the database to this server, and now when we log into QA with the tn user (it has a different password than production, but the same SID), we log in successfully, but HAVE to add the owner qualifier to get the usp_agenda_list sproc to run. When we run it without the owner specified, we get the following error: Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'usp_agenda_list'.
Sorry for the lengthy explanation, but wanted to make sure I was clear on the problem and the obvious SID question.