Why would a select on a single table refer to another table? I have a simple select on a table, but the execution plan shows that another table is involved, in another database. This is definitely a table and not a view and I can't see database auditing turned on so what could cause this?
ok, I actually just worked it out; there is a security policy in place which is causing this, strange though as not even profiler picked that up
Roger