Generic Scripts

bermudabobbermudabob Posts: 5
We've recently put our databases into TFS 2013 with Source Control 3, and all is well with the world.

A query has arisen from our team, and I wasn't sure of an answer.

Basically, each team member gradually builds up a collection of very useful scripts in .sql files that they keep and use for time saving purposes. These aren't stored procedures and aren't tied to a particular database.

Now, we could create a VS project and stash these in that so that everyone can get access to it, but it would be nice to be able to have them available in SSMS directly.

Is there any way to do this? If not, can it be added to the 'nice to have in a future version' list?

Rob Marsh

Aero Developer
Scuderia Toro Rosso F1 Team.


  • The official way is to install the MSSCCI provider and use a "Solution" in SSMS. I put "Solution" in quotes as they're very basic compared to those you get in VS.

    The provider is here:
    http://visualstudiogallery.msdn.microso ... 937d3d88d6
    (you'll need to install the TFS client tools (Team Explorer) as well, but you probably have this already)

    Another way could be to attach useful scripts to SQL Prompt snippets and store these in a shared network drive. This provides sharing, but not versioning.

    I just found an article explaining how it might be possible to achieve sharing using Templates. I've not tried this myself, but it looks plausible:
    David Atkinson
    Product Manager
    Redgate Software
  • Thanks for that - murphys law came into effect and I stumbled over the MSSCCI provider about a minute after I made the post.

    We've gone with this method as its simple and we can group the queries by project for specific scripts with an additional Generic project for non-specific ones.

    Rob Marsh

    Aero Developer
    Scuderia Toro Rosso F1 Team.
Sign In or Register to comment.