Red Gate forums :: View topic - Change Found but "changed By" is unknown
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Change Found but "changed By" is unknown

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
pvanhouse



Joined: 15 Jan 2014
Posts: 6

PostPosted: Mon Jan 20, 2014 10:47 pm    Post subject: Change Found but "changed By" is unknown Reply with quote

SQL Source Control 3.5.4.332 installed on my machine only, and SVN as our change repository.

I created the logging DB (ChangeLog), then had another user drop and recreate a SQL view with a minor change.

When I run Source Control in SQL I can see the change, but the "Changedby" field reads "Unknown"

If I make the change on my machine I see my username.

When I check the table ChangeLog.dbo.RG_AllObjects, I see both changes and the proper usernames.

When I Commit the changes, SVN shows my name as the user (I guess since I did the commit?)

Is this working as designed? Does each user need to have Source Control installed and the commit their own changes in order to properly track WHO made the changes to the database?
_________________
Paul Van House
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Thu Jan 23, 2014 10:12 am    Post subject: Reply with quote

Hi, thanks for your post.

For the second part of your query, the commit as far as SVN is concerned will always be listed against whoever actually ran the commit operation. The person that changed the object in the database is irrelevant.

Some things to check for the 'changed by' showing unknown:

- ensure the other user has made the config file change to point to the changelog DB you set up, the same as you did.
- when they change an object, wait a minute or so before refreshing your commit tab (the polling query to track changes runs at intervals, you may have refreshed and seen unknown as the query hadn't run for the other user yet)
- ensure the change is one that we are able to track. The last part of the article you probably saw earlier lists some of these (see here) - that doesn't sound like the problem in this case though.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group