title: how to transfer stored procedures between SQL Server 2005 databases
body: <p>I'm creating web site on local computer. i'm using SQL Server 2005 management studio. I need to copy all data to destination server. Destination server is SQL Server 2005. My problem is </p>
  
  <ol>
  <li>when i using import/Export data for management studio, this only copy tables. </li>
  <li>when i using backup and restore, tables  and stored procedure shows like this</li>
  </ol>
  
  <p>myuser.aspnet_application</p>
  
  <p>myuser.aspnet_Membership ... etc. 
  I need to create like this</p>
  
  <p>dbo.aspnet_application</p>
  
  <p>dbo.aspnet_Membership</p>
  
  <p>How to copy stored procedures and views to destination server?</p>