title: System.Data.SqlClient.SqlException: Could not find stored procedure - Issue while accessing stored procedure in different schema
body: <p>I can see below error while starting one of the windows service.I am seeing error in one of the web application hosted in same server also.Both are connecting to same database.It was working without any issue for last two years and suddenly appearing these errors in event viewer</p>
  
  <pre><code> System.Data.SqlClient.SqlException: Could not find stored procedure 
   'psp_SDT_SRV_Insert'.
  </code></pre>
  
  <p>Issue happens while connection stored procedure inside 'dgo' schema only.But I can access all procedures inside 'dbo' schema.</p>
  
  <p>When i tried created Windows Form application and trying to access the same SP,i didn't face any issue.All these apps using same connection string</p>
  
  <p>Connection string is as follows</p>
  
  <pre><code>  &lt;add name="connectionstring" connectionString="server=PGSI.PA.YA.NET\INST1;database=CustomerDB;integrated security = true" providerName="System.Data.SqlClient"/&gt;
  </code></pre>
  
  <p>Can anyone advice how to resolve this issue ?</p>