View changes by date / user

ipellyipelly Posts: 4 New member
in SQL Source Control
Is it possible to review history by date or user? e.g. I'd like to see all the updates made in February, or all the updates made by user Joe. Thanks.
Tagged:
· Share on Twitter

Best Answer

Answers

  • ipellyipelly Posts: 4 New member
    Thanks Alessandro - you are correct. I could do that... it's a bit painful, in that there are 25 databases under source control in 25 different areas of TFS, which, unless I'm missing something, means I have to find and query them one by one. It'd be way easier if a mechanism to search/navigate the changes were built into the SQL Source Control UI within SSMS. But thanks!
    · Share on Twitter
  • AlessandroAlpiAlessandroAlpi Posts: 91 Gold 2
    Using VSTS it's possible to query the histories also parametrising the query itself. However I don't know what's your one.
    Alessandro Alpi
    CTO @ Engage IT Services s.r.l.
    Database Administrator and Team Leader
    Microsoft MVP - Data Platform
    Staff member of getlatestversion.it community
    personal website | blog
    · Share on Twitter
Sign In or Register to comment.