title: Can't find stored procedure
body: <p>When I try to update my table's data, I'm getting error </p>
  
  <blockquote>
    <p>Can't find stored procedure</p>
  </blockquote>
  
  <p>What's wrong?</p>
  
  <p><strong>SQL:</strong></p>
  
  <pre><code>CREATE PROCEDURE GetContactName
     @Name char(20),
     @SecondName char(20) output
  as
     SELECT @SecondName = [Second Name] 
     FROM WPF.dbo.contacts 
     WHERE Name = @Name
  </code></pre>
  
  <p><strong>C#:</strong></p>
  
  <pre><code>sqlConnection.Open();
  SqlCommand cmd = new SqlCommand("GetContactName", sqlConnection);
  cmd.CommandType = CommandType.StoredProcedure;
  
  SqlParameter param = new SqlParameter();
  param.ParameterName = "@Name";
  param.SqlDbType = SqlDbType.Char;
  param.Direction = ParameterDirection.Input;
  cmd.Parameters.Add(param);
  
  param = new SqlParameter();
  param.ParameterName = "@SecondName";
  param.SqlDbType = SqlDbType.Char;
  param.Size = 20;
  param.Direction = ParameterDirection.Output;
  cmd.Parameters.Add(param);
  
  cmd.ExecuteNonQuery();
  sqlConnection.Close();
  </code></pre>
  
  <p><strong>Edit1</strong></p>
  
  <p>I'm using VS13 and SQL Server 2008 Management Studio.</p>
  
  <p>I can't find stored procedure, but when I'm executing the SQL code, it says that the procedure already exists.</p>
  
  <p>Connection string:</p>
  
  <pre><code>Data Source=HOME;Initial Catalog=WPF;Integrated Security=True
  </code></pre>
  
  <ul>
  <li>Database : <code>WPF</code></li>
  <li>Schema: <code>dbo.contacts</code></li>
  </ul>