>>>Hi everybody,
>>>
>>>I'm just wondering if there is a way in SQL Server to permanently set some template parameters, say, the author name.
>>>
>>>Thanks in advance.
>>
>>SSMS:
>>View->Template Explorer.
>>Right click on template then choose Edit. Do whatever you want to do and the Ctrl+S
>>(not tested)
>
>It shows the templates, but then you press Edit it looks like it just opens a new Query editor with this template. It doesn't look like this new template is saved as a template.
It was saved to me. I opened "Create Procedure with CURSOR OUTPUT Parameter" for edit.
The changes a comment and add --- Boris was here --- Then pressed Ctrl+S to save it. Then close Query editor. Opened the template again and guess "Boris WAS here" :-))))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.