metalyric
Starting Member
1 Posts |
Posted - 09/15/2005 : 21:44:49
|
hi all,
i had to re-install my sql server, so got my back-up of my database. today i restored it after re-installing sql server.
now it has every table and sp as before; but my app gives "could not find stored procedure <storedProcedureName>"
i checked the database, and sp is there. besides the ownership cannot be a problem, because i'm trying to connect to the database with the right username (who has the ownership for that sptored procedure)
i don't have any idea about that problem, do you?
thanks all.
|
|
derrickleggett
Pointy Haired Yak DBA
USA
4184 Posts |
Posted - 09/16/2005 : 00:12:19
|
Have you tried running sp_change_users_login 'REPORT' to see if you have a user out of synch? If you do, you then need to run: sp_change_users_login 'auto_fix', 'UserName'.
MeanOldDBA derrickleggett@hotmail.com
When life gives you a lemon, fire the DBA. |
 |
|