title: Executing SQL from Server Explorer in Visual Studio 2010 (ALTER TRIGGER, CREATE PROCEDURE etc)
body: <p>I am currently modifying a web application to use a MS SQL 2008 database with will be located in the app_data folder and auto-attached.  Everything is fine and I can connect to the database and query it from within the application and also Visual Studio.</p>
  
  <p>Although I need to also create/update some triggers and stored procedures, which I can not do - every time I choose the 'Add new stored procedure' from the right click menu in Visual Studio's Server Explorer menu, it creates a new template but I am unable to execute it, as there are not options enabled on the 'Query Designer' tool bar.</p>
  
  <p>Maybe I am doing something completely wrong, but surely it should be just a case of creating my stored procedure and then clicking an execute button?</p>