Changed by 'Unknown'

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

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Changed by 'Unknown'

Postby kevine323 » Thu Jun 02, 2011 4: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
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/
kevine323
 
Posts: 39
Joined: Thu Jul 27, 2006 10:23 pm

Postby james.billings » Thu Jun 02, 2011 7: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.
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

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

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
Chris Smith
Project Manager
Deployment Manager
csmith
 
Posts: 118
Joined: Thu Jun 30, 2011 2:15 pm
Location: Cambridge


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests