Yes, I'm sure.

You would need an intermediate SSIS or ETL step to read the original file back using the built-in audit log reader function and output it to the format you desire.

Thanks for your reply. Actually, you can't have these go directly to table, they must go to a file first. Unfortunately.

So you don't have to provide any sort of reporting on the trace files? No requirements on retention?

Hey Gail, yeah, the tables that CDC creates and writes to are system tables.

Thanks, but like I mentioned - "I won't always know that 'Blue', 'Black', or 'Green' are going to be the distinct values."

Interesting. Thanks!

Don't mean to pile on here, but yeah. I fail to understand why someone would query this data in this fashion. Yeah, it improves performance for that query but it's...

Ok, thanks for the clarification.

Ok, thanks, do I have this right? If you want to use an index to assist in a join, it should be on the joining table, not the base table?

Done

Does it matter if that UDF doesn't touch the table dealing with the Key Lookup?

I'm connecting locally.

No. How or where do I do that?

Windows Server 2008