Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
metalyric
Starting Member
1 Post |
Posted - 2005-09-15 : 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. |
|
Stalker
Yak Posting Veteran
80 Posts |
Posted - 2005-09-15 : 23:47:40
|
can you execute your SP from Query Analyzer ? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-16 : 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'.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|