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...

lmu92 (5/4/2009)

---

You probably need to...

I have to vote for It Depends. I tend to do it both ways, it all depends what I am doing. For single variable sets, I tend to...

Indianrock (5/4/2009)

---

If installing a sql service pack has the potential to break things, then it should be installed in Dev and tested first. Perhaps this is no longer a...

Please post the complete query.

Have you tried this:

SELECT description

FROM tab1

where description = '''%' + @Description + '%'''

Please note, that is three single quotes at the start and end.

I don't think you'd win such a lawsuit. If auto updates are enabled, you have instructed the OS load patches/updates. If you haven't, and it installed along with...

Did you try this:

where

isdate(LTRIM(RIGHT(t1.sent_info, 19)))= 0

First, let me clarify that I learned about lmgtfy from another poster on SSC (name unknown); but it looks like I've created a monster by using it myself as it...

I prefer the...

For what you are trying to accomplish the SUM() OVER (PARTITION BY ...) does not work as you have found. These window functions haven't been fully implemented for that...