Just to clarify, it's not about coping the contents of the store procedure, it's about generating code to execute the stored procedure from another script.  For example... declare @rc as int decalre @arg1 as varchar(10) decalre @arg2 as varchar(10) set @arg1 = '???' set @arg2 = '???' execute @rc = usp_mystoredproc @arg1,@arg2 The second

Within SQL Management Studio, you can right click on a stored procedure and have it generate code to execute that procedure (either into the clipboard or a new query window).  You can also have it generate code to select, insert, delete, and update from a table. Does this functionality exist in SQLDBControl?  This is a nice ...

Is there a way to use a template when creating a new stored procedure?  For example, we like to have a comment section at the top of our stored procedures which shows the author, date created, description, and change history.  I would image an option somewhere that you can point to a file to use a the template.

I like the idea of having a formatter but I will be difficult to implement something that will work for everyone.  I like having the commas in front of the columns as indicated above.  I also like to right justify the first keyword on a line and then left justify everything else.  This is how I would like the format to be ...