The most likely cause of the changed-by column not being there is if you linked up with the "dedicated" option set. When working in dedicated mode, we assume you are the only user of the database and the column is not shown.
If you're actually using shared mode, where you work on the same DB as others, then you just need to unlink and relink selecting "shared".
For full details on the differences, see here
james.billings wrote:There's a lot of reasons for seeing "unknown".
If you've not changed the configuration in any way, then we read the information from the default trace in SQL Server. This can roll over alarmingly regularly on a busy server, at which point we cannot retrieve the information, so you see "unknown".
The trace also requires SA permissions to read it I believe, so this would also be a possible cause.
To overcome some of these issues you can configure a separate database to log changes. See http://documentation.red-gate.com/displ ... +databases
Note that some changes don't get marked in the trace at all, and will always show unknown. There's a list at the bottom of the page linked above.
Users browsing this forum: No registered users and 1 guest