How to set the default author name in MS SQL 2005 stored procedure template in management studio?

Question

Hello gurus,

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.

Thanks,

Cullen

Answer 1

Hi you can completely edit what appears in the templates in Management Studio by going to View->Template Explorer-> Expand Stored Procedure.