Thanks, that is pretty slick (and pretty fast also).

My actual tables have additional columns (modified date, guid, others... I should have included some of them in the test) ... to...

I think that this is one...

Carlo Romagnano (4/16/2009)

---

Correct answer is 1-25:

exec sp_helptext sp_addmessage

in the output search for @severity and you'll find this piece of code that is the law.

...

Jeff Moden (1/3/2009)

---

OK... here we go. --===== Do the "pseudo cursor" update to determine which rows to keep

=====================================================================================================================

UPDATE #MyHead

SET @PrevKeep = KeepMe =...

Thanks for the great article.

I also am waiting for the rest of this series. Hopefully, the wait is just daily.

I have a new job. With a simple

select object_name(object_id), * from...

RJ (4/14/2009)

---

RBarryYoung,

I would like to see how you can eliminate using a CURSOR or WHILE loop for sending emails using "msdb.dbo.sp_send_dbmail". My requirement would be to send email notifications to...

I like this thread, though from a different perspective. I like how the replies to the poster encouraged the poster to provide run-able code to duplicate the issue, and also...

The thing I...

ssaari (3/25/2009)

---

Why didn't they bother to include a copy of a working version of the script? I have yet to see a script on this site that works as...

Well, 18 hours after it was sent, I finally received that email.

However, the original question remains. In all of the msdb..sysmail objects, can a sent email be set to be...

It's in sysmail_allitems, with a status of sent. As well as the other emails that I...

The database mail is working... I've received mails both before and after the missing one.

And the emails are set up with a filter to go into a specific folder, so...

The feedback on this article has been very interesting. And good enough that I've been looking at other ways to accomplish what I'm using the Excel Automation for.

So, let me...

Interesting.

I modified the supplied code to get the # of tempdb objects, and all tempdb table names:

use AdventureWorks

go

select count(*) from tempdb.sys.objects

select name from tempdb.sys.tables --where name like '%tableA%'

declare @tableA TABLE(col1...

I just recently upgraded a database from 2000 to 2008. There was a bit of code that had to be looked at for depreciated and obsolete features. (Granted, the upgrade...