Comments
Sort by recent activity
james.billings wrote:
Hi,
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
Thanks Jim. This is what I needed. Do you think database administrators typically use shared mode rather than dedicated? On a somewhat different topic, should I be able to see who changed an object (rather than just seeing "Unknow" in the changed by column) more readily than a developer without sysadmin privileges? Or are there a number of reasons that there can be the value "unknown" in the column? Thanks again! / comments
james.billings wrote:
Hi,
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 th...
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.
I have all the information I need now. Thanks for answering my questions Jim. / comments
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 c...