Source Control & global user-created sp's in master (sp_%)

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Source Control & global user-created sp's in master (sp_%)

Postby David A » Wed Dec 01, 2010 5:06 pm

The "Setup" page does not allow a link to be created for any system database, including model.

We have many routines in the master database that have been written to be run from within any database and dynamically act on objects within that database's context. For example, we have 500+ databases, many using table partitioning. Several routines generically & dynamically split/merge/truncate/index/rebuild/validate partitions and partition column values for any database.

Like sp_help (which will show object information for the database context from which it is executed), these routines must exist in the master database.

How do we check these routines into Source Control?
David A
Posts: 8
Joined: Mon Apr 21, 2008 4:48 pm

Postby james.billings » Thu Dec 02, 2010 8:11 pm

Unfortunately, I don't believe you can do this right now. We only enable the option on User DBs.

I'd suggest you visit our UserVoice page for Source Control and suggest the feature - if enough other users vote for it, then we can look at adding it in the future. You'll find the page here
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests