I give Visual Studio Team System 2008 Database Edition (GDR version) a transition to a new project that I am working on and faced with a slightly annoying problem that I hope someone knows how to solve.
In short, I would like to modify the default templates used to create database objects, especially stored procedures. Previously, using SSMS, I just created my own templates, which contain formatting, the number of default parameters, etc., which I usually would like to use whenever I create a new sproc. This obviously eliminates a good amount of manual coding and just “feels good” for me to have some consistency in my T-SQL code.
I tried editing the .sql files located in .. \ Microsoft Visual Studio 9.0 \ DBPro \ Items, adding the formatting and default constructors that I would like to use. Unfortunately, I could not get VSTS to recognize these changes. When I add a new stored procedure using the GUI, it still uses the default formatting of stored procedures.
I tried disabling Visual Studio and starting backing it up after making these settings, but this seems to have no effect.
Does anyone know how to do this? I could not find any documentation on MSDN blogs or DBPro blogs, but I have the feeling that it can be done. Any help or suggestions would be greatly appreciated.