Thank you!

...and while you're at it. Can you also mail it to me, Joe?  

No, for UDF's you need to query directly the system tables. I'm a bit short now, since I have a meeting right now and am already late. Search the script...

If you don't have Stored Procedures that exceed 4,000 characters, this will work

SELECT

 *

FROM

 INFORMATION_SCHEMA.ROUTINES

WHERE

 ROUTINE_DEFINITION LIKE '%mail%'

That way, you get a list, you can subsequently work on....

Much appreciated, Dave!!!

Btw, you give me the rare opportunity to post this smilie

Cheers!

SELECT

...

WHERE

 DATECOLUMN >= DATEADD(m,-6,DATEDIFF(d,0,GETDATE()))

goes always 6 month from the current date back in time.

And another one: http://www.sqlcourse.com/

Not only this, but I also think this here is SQL Server country. Probably there are better places to ask this question.

Maybe http://www.orafaq.com

??? What does this mean ???

During the past 5 (+-) years or so, one might be inclined to consider this an advantage.

Don't look too closely at this system table map. The next version will turn several things here upside down.

Boy, oh, boy. This is the kind of stuff that makes monday morning a whole lot easier!!!

There are so many response here right now, that I again want to express...

You have changed yours. I'll take this chance to open up a new thread on this!

Hey Scott, now that you've stepped out of the dark, there is no excuse not to post here.

Curtis, I try to stay on...

This part

 IF (@ChangeRate < 1)

 BEGIN

 ELSE

looks strange.