Don't know if anyone cares, but I ran into one that I could not find listed in the BOL under "SET Options That Affect Results" which definitely does cause a...

Sorry for the late bump.

We implemented a solution to address audit concerns by:

1. Creating an internal tool to define:

A. Schema of tables of audit interest and...

Indeed... in fact both of them.

Cheers.

No thanks, it's fine now.

GilaMonster (9/8/2010)

---

Experience 😀

Also known as 'been there, done that, got my...

Grant, thanks... I'll review.

Gail, thanks. Attached are the execution plans and table definitions. I have whittled all but the one table out of the query and removed the "so_ref not like '% VS'...

Sorry, I was away for most of last week and just tried this. I've never noticed the DBCC InputBuffer statement before. Wonderful.

Thanks to all who responded.

We had the same issue.

We have a dynamically assigned security model that allows different levels of heirarchy in an organization to view data by creating where clauses which include or...

I absolutely love sox, both from a design and architectural point of view. Many lower level developers misunderstand the purpose of sox. It's not about audit logging infinitum, but rather...