Comments
Sort by recent activity
Thanks Jessica for coming back to me.
Yeah all users are seeing Unknown for their changes and everything is showing up as changed by "Unknown".
"Unknown" is clickable. On click, a popup shows with the title "Permissions problem - user unknown" and with the following message:
"SQL Source Control uses the default trace to work out which user made which change.
You don't have the correct permissions to access the default trace, so the information isn't available.
To get the correct permissions, make sure your server login is added to the sysadmin server role."
All users are db-owner. We've tried creating a new log database as well and users have permissions to alter trace and view database state and other permissions listed in he documentation. But still doesn't work.
Any advice or help would be much appreciated.
Thanks
Sam / comments
Thanks Jessica for coming back to me.
Yeah all users are seeing Unknown for their changes and everything is showing up as changed by "Unknown".
"Unknown" is clickable. On click, a popup shows with...