title: Stored Procedure Not Create with dbo Schema
body: <p>I have folder with stored procedures in my project so when installing application it reads the stored procedure file and executes it on the server. </p>
  
  <p>The problem is when sp name has <code>dbo</code> schema (<code>CREATE PROCEDURE dbo.Procedure</code>) it doesn't create sp on server, whereas if it doesn't have <code>dbo</code> (<code>CREATE PROCEDURE Procedure</code>) it will create sp on the server </p>
  
  <pre><code>string sql = System.IO.File.ReadAllText(filePath, System.Text.Encoding.UTF8);
  var smoServer = new Microsoft.SqlServer.Management.Smo.Server(new Microsoft.SqlServer.Management.Common.ServerConnection(cn));
  smoServer.ConnectionContext.ExecuteNonQuery(sql);
  </code></pre>
  
  <p>is this because of a server configuration issue or something else ?</p>
  
  <p>thanks</p>