Grant Fritchey (5/5/2009)

---

You're way too nice Lynn. I would've walked away. If I need people yelling at me when I'm trying to help, I can go home & help the...

Then you have those that would bite the hand that is trying to feed them.

Also, there is a slight problem with your table and the data that you are trying to enter that needs to be addressed.

This is the code for your table:

CREATE TABLE...

Amit Lohia (5/4/2009)

---

Roy,

You beat me on this. Even I wrote a paper of TDE and was waiting to have an answer for the Disabling TDE issue before I publish. Your...

Yelling at me doesn't help. I have looked at the previous posts, and I'm sorry but I don't see the expected results detailed for us....

Okay, part way there on the expected results, you described what you wanted, but you didn't show it. By showing the expected...

Did you perchance read the article I suggested? I don't see any sample data or expected results.

Jeff Moden (5/4/2009)

---

Not a bad recommendation... I just do it all from T-SQL. I hope to...

Or, create a view over the tables created by the replication of the two indexed views so that it appears as one table. Name the view the same as...

Should have taken the...

There have been several threads regarding MySQL Linked Servers; here, let me google that for you.

The problem I had with the install of SP 3 on a test server wasn't related to WSUS loading something, what was missing was the .msp files from the install...

Anyone else as confused as me about this one?

I'm confused. It looks like you created two indexed views, and are joining those two views together to recreate the original table. Why?

Balaji (5/4/2009)

---

Hi, I couldn't able to create clustered unique index on view. The view using lots of derived table and self join.

Could you please help me out how to restructure...