Way to see the history of *just one object*

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

Moderators: Chris Auckland, David Atkinson, Paul Stephenson, sherr, PhilScrace, andy.campbell.smith

Way to see the history of *just one object*

Postby sgilboy » Mon Oct 28, 2013 3:48 pm

Is there some way to see the revisions for just a single object in the database?

Having to go through one by one through the list of every revision to fid the last time an object was checked in is pretty clunky
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm

Postby andy.campbell.smith » Wed Oct 30, 2013 4:47 pm

If you right-click the object in the Object Explorer and select \"View history\" you should be able to see just the revisions that involve changes to that specific object.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby sgilboy » Wed Oct 30, 2013 5:23 pm

that is not the behavior our install (version 3.5.1.69) does

see:

right click the PROC, view history:

Image



this is the result which has ALL stuff ALL revisions in the list:

Image
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm

Postby andy.campbell.smith » Wed Oct 30, 2013 5:34 pm

Hmm, that's odd - it seems to work for me locally on the same version of SQL Source Control. Can I ask what you're using for your source control system?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby sgilboy » Wed Oct 30, 2013 5:45 pm

Source Gear vault version 6.1.0.531
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm

Postby andy.campbell.smith » Thu Oct 31, 2013 11:51 am

I've had a chat with the developers - it seems this is a known issue, and we've already got a fix in the works. That ought to be rolled out as soon as it's gone through testing - I can't promise an exact date, but it ought to be released within a week or two. Sorry about the inconvenience!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby sgilboy » Tue Nov 19, 2013 5:11 pm

looks like this issue is addressed in yesterday's 3.5.2.350 release... as soon as I get a chance to install I'll be doing so...

thanks for listening !

* EDIT *

Patch applied and appears to be working as desired !
sgilboy
 
Posts: 30
Joined: Wed Jun 22, 2011 7:38 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests