Here is the query to do that:

SELECT EXR.session_id,

EXR.blocking_session_id,

EXR.command,

...

Jeffrey Williams-493691 (3/26/2010)

---

Lowell, it would be better to use an open interval range check instead of between. It could also cause problems if you are using SQL Server 2008...

Jose Julio Mota Duarte (3/28/2010)

---

Msg 3023, Level 16, State 2, Line 1

Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the...

There's...

The log cannot be cleared until the concurrent backup operation completes.

See http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-16-Concurrent-log-and-full-backups.aspx

A file activation error occurred. The physical...

Mani-584606 (3/27/2010)

---

Hi,

We enabled the below Trace flags as suggested by MS to investigate a sql dump last year when we are on SQL Server 2005 with SP2 and Max memory...

Lynn Pettis (3/26/2010)

---

Unfortunately, there isn't...

The article I wrote on APPLY is in the queue for publication.

Jeff Moden (3/27/2010)

---

And now we know why I've gotten in the habit of aliasing all column names. Out of habit, it's even bled over into queries that only have...

RBarryYoung (3/27/2010)

---

Nice idea Paul. I've tried some things like this in the past, but I could never seem come up with a query pattern that would be retain a...

One more alternative, that is optimized well:

SELECT *

FROM TableA

WHERE @Type = 'Lname'

AND Lname = @Value

UNION ALL

SELECT *

FROM...

Brad Schultz's comment on your blog entry summarises my views on this nicely.

Use the ADSI provider:

http://www.lmgtfy.com/?q=sql+server+ADSI+%22linked+server%22

Lynn Pettis (3/26/2010)

---

This can be done using a tally table and eliminate the loop. Give me a bit and i'll be back with some code. May not be...

There is a complete step-by-step guide here:

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Be sure to follow the steps exactly, especially the part concerning the MSDASQL provider properties 😉