Riddhi Valecha

Riddhi Valecha

  • 444
  • 3.3k
  • 412.6k

dbo and dbo_owner schema

Aug 4 2015 1:52 AM
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.
 

Answers (5)