I belive Redgates tool can do it.

Idera can do it as well.

Since you already have the execute sql task and a query, why not alter it a bit and use sp_send_dbmail?

http://msdn.microsoft.com/en-us/library/ms190307(SQL.90).aspx

jcrawf02 (2/24/2010)

---

String parsing like cleanup? Or extracting elements?

Just started playing with xQuery, just curious how it would compare (now I have to go find out) [rant] who stores xmldata...

tstaker (2/24/2010)

---

Lynn Pettis (2/24/2010)

---

I have to disagree here. This is a good way to see how some thinks. Do they write a cursor or while loop to complete...

:hehe::hehe::hehe::hehe:

Thanks Ron. Good question

No

Lynn Pettis (2/24/2010)

---

My problem with comparing the two solutions above is you are actually comparing apples to oranges. Jason's routine is returning the results directly...

Why hire a Sr. DBA when you can hire 4 Jr. DBA's?

(seen it in real life)

I had this topic come up the other day outside of the forums. When I recounted to my wife, she asked if i told them to try dbcc timewarp.

Dang...

doctor

Just a thought. Did you backup the database prior to upgrading it or restoring or attaching it to the sql 2005 instance? If you have that backup and...

reidres (2/23/2010)

---

OK, I ran Jason's (CirquedeSQLeil) updated code (modified by me as before) and got 0:54, which puts it as the fastest time of the scalable three that I reviewed....

Manie Verster (2/23/2010)

---

CirquedeSQLeil (2/23/2010)

---

Manie Verster (2/23/2010)

---

One point in all this that you are missing is that when a person is in an interview, no matter how tough you are, you...

Manie Verster (2/23/2010)

---

One point in all this that you are missing is that when a person is in an interview, no matter how tough you are, you are nervous and...