title: How do I save a stored procedure in SQL Server 2008 R2?
body: <p>I am writing a SQL Server stored procedure for the first time and am unclear on how I can "save" my stored procedure so that it appears under <code>Programmability, Stored Procedures</code> in the Object tree. </p>