I'm using sql server 2008 and Sql Server Management Studio.
I have some scripts to create some stored procedures.
I already know how to execute one stored procedure at time in Sql Server Management Studio.
I just copy an paste the script into SSMS and then click Execute.
I have like 100 working stored procedures, so doing one at a time this way will take a bit.
If I have 4 stored procedure scriptes called the following:
How do I execute these 4 scripts all at once using Sql Server Management Studio?