Changed by 'Unknown'

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

Changed by 'Unknown'

Postby kevine323 » Thu Jun 02, 2011 3:56 pm

Is there a reason why the "Changed By" column on the Commit Changes tab would be "Unknown" for some users but have a value for others who changes objects?
Kevin Eckart
Database Administrator
USA Truck, Inc
Posts: 40
Joined: Thu Jul 27, 2006 9:23 pm

Postby james.billings » Thu Jun 02, 2011 6:58 pm

The changed by information is obtained from the default trace as I understand it. This means the users need permission to read that to be able to view the user that changed the object.

Another possibility is if the trace has rolled over to a new file between the object being changed and someone viewing the commit tab - the information about the change will not be present any longer, so unknown is displayed.

If you hover/click on the unknown column, it may give an extra hint as to the problem.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby csmith » Fri Jun 08, 2012 2:46 pm


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: ... hp?t=15345

Chris Smith
Project Manager
SQL Lighthouse
Posts: 120
Joined: Thu Jun 30, 2011 1:15 pm
Location: Cambridge

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests