GOOD idea, sure, here is the code:

SELECT col1,

col2,

Max(CASE col4

...

I figured it out, just like you said, I used MAX around each CASE statement and it ran like a charm. Thanks!

Forgot, I have also tried PIVOT.

That's exactly what I am trying right now! 🙂

I got this so far:

SELECT col1,

col2,

CASE col4

...

I should have done a more detailed research....apparently there is a is_primary_key column in sys.indexes.

Since you posted this to the SQL Server 2005 section, I am guessing that you are trying to restore a 2008 backup on to a 2005 server, which is impossible.

But...

Thanks very much guys, I really appreciate the input. I guess I'm going to have to wait until we upgrade to SQL 2012 and then play around with Event...

WOW, was searching for that info all over and for a long time, THANK YOU! Yes, that is the object I need.

Understood, thanks for that, makes sense. I also didn't know what the best way of doing an update would be.

I opened another thread about CDC net changes behaving "strange",...

I'm still not sure why the delete doesn't show, but I set @supports_net_changes to 0 now and then used cdc.fn_cdc_get_all_changes_dbo_test1 instead to get all the rows, including the delete. ...

Yes sir, that's where the error is, thank you!!!

I also set everything on the Error Output window to Ignore Failure and the execution still fails on the CDC Source task. 🙁

I added a breakpoint on the CDC Source and looked at the Watch window...nothing there. Any help would be appreciated. Thanks.

Hi Lynn, I tried putting the mouse on the X and it doesn't show any popups. As the picture shows, there are no errors listed in the Error List...

Thank you for your help, I appreciate it. Based on your response, I think that using CDC with net changes is the right fit for us. I have...