2

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.

Leo Nix
  • 2,085
  • 2
  • 24
  • 37

1 Answers1

3

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

Andrew Corkery
  • 1,024
  • 1
  • 8
  • 13
  • Thanks Andrew! Is there a way to stamp create date with the current machine date automatically? – Leo Nix Mar 10 '09 at 11:51
  • 1
    Hmm. that's a good question. I don't think so, as the token replacement functionality just expects "", which corresponds to the columns in the Shift+Ctrl+M menu (specify values for tokens). Can't call getdate() or whatever. As far as i know anyway... – Andrew Corkery Mar 10 '09 at 12:11