>>
>>I use APEX SqlEdit so it doesn't make difference for me what SQL Server I connect to.
>
>I will google to find out what is APEX SqlEdit (thank you). But I need to still understand this simple task of adding a sproc to a database using Server Management Studio.

It's commercial product http://apexsql.com/sql_tools_edit.asp