title: SQL Server: Script all DB objects (SP, Tables, Triggers, etc.) to SQL script
body: <p>I would like to ask the experts here on how to script the database objects in SQL Server 2008 Express Edition. When generating scripts, I found out that only tables and triggers are available to be script. But how can the SPs be scripted too? </p>
  
  <p>The problem is that I have a host provider and I wanted the database in my site to have ASP.NET membership framework objects (tables, SPs). It is a big disadvantage because my host does not allow remote access to their SQL Server.</p>
  
  <p>I wanted my site's database to have objects of ASP.NET membership framework. What they allow is SQL scripts using "my little admin" tools.</p>
  
  <p>Any help will be appreciated. If my question is not clear enough, please post a comment so I may revise the question.</p>
  
  <p>Thanks!</p>