In MS SQL Server Management Studio Express, is there a way to set the default author name to my name when I create a stored procedure by right clicking on the "Stored Procedures" folder under "Programmability" folder? It would save me a lot of time if I don't have to keeping updating it whenever I create a new stored procedure.
Hi you can completely edit what appears in the templates in Management Studio by going to View->Template Explorer-> Expand Stored Procedure.