title: Copy entire database contents (schema and data)
body: <p>I need to copy the contents (tables, views, procs, DATA, etc.) of a SQL Server database and copy it to another SQL Server database.  I need to do this entirely in a script as I am not able to carry over files to the destination web server.  Using Microsoft SQL Server Management Studio, how can I accomplish this?  </p>
  
  <p><em>Note:  The database I am copying to will have the same name and be completely empty.</em></p>