Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Templates and teamwork


Templates and teamwork

Author
Message
David.Poole
David.Poole
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5924 Visits: 3230
Comments posted to this topic are about the item Templates and teamwork

LinkedIn Profile

Newbie on www.simple-talk.com
JP-317675
JP-317675
SSC-Enthusiastic
SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)SSC-Enthusiastic (161 reputation)

Group: General Forum Members
Points: 161 Visits: 90
Are there any plans to be able to specify a team repository for templates in SS 2008?

We had to implement a similar solution as outlined in the article which works fine but it would be great to not have to run a batch script.

-- JP
CAGreensfelder
CAGreensfelder
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 375
Looks like the editor "ate" most of your code blocks. Sad

What does the XCOPY command look like?
Pedro R. Lopez
Pedro R. Lopez
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 140
I always wanted to share my code snippets and templates. Really nice idea. Thanks.

Pedro R. Lopez
http://madurosfritos.blogspot.com/
David.Poole
David.Poole
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5924 Visits: 3230
CAGreensfelder (5/20/2008)
Looks like the editor "ate" most of your code blocks. Sad

What does the XCOPY command look like?


What browser are you using? In FireFox the code block gets a scrolling window.

LinkedIn Profile

Newbie on www.simple-talk.com
CAGreensfelder
CAGreensfelder
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 375
I'm using IE7 on WinXP Pro 2002 SP2, all patches applied. Over half the code blocks in this article come up as a horizontal scroll bar only - no vertical. This happens occasionally. Guess I should report it to webmaster when it happens. They can't fix it if no one tell 'em it's broke.

I looked at the page source and found the bits I was interested in.

We use SQLMS with Visual SourceSafe. We've got 3 developers each working with thier own local dev SQL server. We wrote templates for the CRUD stored procedures and a few other tools with our shop headers and standard error handling.

We have separate SQLSM projects for different areas of the application in the SQLMS solution and we included a project for the templates. But rolling out the templates to the actual template folder has been a pain - that's one LONG path. (We finally stuck a text file in the Templates project with the template file path name so we could remember it. It shows up in the Misc folder in the project)

Now I've got a batch file in the project to XCOPY the templates. Much easier to just double-click the batch and let it remember where the templates go.
Anipaul
Anipaul
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6845 Visits: 1407
Good article..........



Ian Crandell
Ian Crandell
SSC Veteran
SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)

Group: General Forum Members
Points: 289 Visits: 1093
Good article. I have used the templates, but I like your method of getting team templates distributed.

CAGreensfelder - I have a similar setup as you and the code blocks don't show right either. I've found you can highlight the block, copy it and paste into something like notepad. The text will show up then. It seems to happen when there is just one line in the block.

Ian.

"If you are going through hell, keep going."
-- Winston Churchill
myrogers
myrogers
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 13
You can customize your templates by following the following advice. Using this method you would be able to get rid of the unused templates and create new ones suitable to your profession that can be shared.

Steven Twitchel from MSFT wrote in another forum on October 13, 2006
Management Studio was designed with multi-user environments in mind. When SSMS starts, it checks a "common template folder" for templates and if any template is missing in a user's folder, it is copied from the common location. This lets an administrator add a template to a common location and all the users on the machine will automatically get a copy when they start SSMS.

If you want to permanently remove a template, first delete the file from ...\Documents and Settings\{user}\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\Templates\... (this removes the user's private copy), then remove the common template from %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems. Once the common version has been removed, SSMS won't be able to copy it to the user's template directory during application startup.


This works in SSMS 2008 using:
\Documents and Settings\{username}\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql – for the private copy

%Program Files%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql – for the common version
CAGreensfelder
CAGreensfelder
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 375
Do you have a link to the article? I'm not finding anything on my searches.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search