SQL Source Control source trace

jsaunijsauni Posts: 4
I understand that SQL Source Control uses the default trace to populate the 'Changed By' column.

Because the default trace recycles over so quickly, this value is always Unknown. Is there a possible setting to change the trace SQL Source Control points to for this info? In theory a custom trace that retains more historical info so this value is appropriately populated.

Comments

  • csmithcsmith Posts: 140 Bronze 1
    Hi,

    I'm afraid you cannot configure the trace SQL Source Control points to for 'Changed By' reporting. However, you can tune the frequency SQL Source Control polls the database which may help reduce how often the trace recycles - please see the thread below for details:
    http://www.red-gate.com/MessageBoard/vi ... hp?t=14503

    We are currently working on a fix to reduce the frequency of the Unknown issue. When we have completed that fix, would you be interested in trying out a build to see it this resolves the problem?

    Best regards
    Chris
    Divisional Development Lead
    Redgate Software
  • csmithcsmith Posts: 140 Bronze 1
    Hi

    An Early Access Release of SQL Source Control v3.1 is now available that includes a solution to the 'Changed by = Unknown' problem.

    For more details, and a download link, please see:
    http://www.red-gate.com/MessageBoard/vi ... hp?t=15345

    Thanks,
    Chris
    Divisional Development Lead
    Redgate Software
Sign In or Register to comment.