Hi..
I shifted my database from one server (10.1.1.2) to other (10.3.4.10)...
My Database Name is - EMPLOYEES
There are total - 25 stored procedures in it.
Now; 15 stored procedures have schema - .dbo and rest 10 have scheme - .db_owner.
Issue - From the new server (10.3.4.10) ; stored procedures with db_owner schema are not executed from front-end asp.net c# ; it gives an error - "Could Not Find the stored procedure).
But ; the database has the stored procedure.
Please guide. How to solve this issue.