SP Owner | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SP Owner

Hi I have a problem in accessing stored procedures..it shows the owner of the SP is somebody who is not a user in server. It is probly because we took the back up from other server and restored in our server. But when we try to access those SPs using ado.net it says could not be found.Please tell me what’s the problem? Kiran
There are 2 ways to solve it. if you need this user on your server than just add it and is should work fine. Rememner to run sp_change_users_login under that database after you add the user so it will correct the SID.
If you don’t need this user in your database, you can change the object owner. sp_changeobjectowner ‘object_name’, ‘new_owner’ Bambola.