Think I figured it out...I'll just use 2 case statements instead....seems to work:

, case when MAX(s.last_run_date) > 0 then

case s.last_run_outcome

...

You can try this:

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]

--31/01/2012

More SQL Time Formatting Examples:

Date Formatting

Thanks! You helped me greatly....and you are correct, I had to take into account the Years of the dates as well.

I think (**hope**) I have thought of all the...

The following will show you a listing for all DDL triggers on your dB, including Database and Server-level triggers:

SELECT * FROM sys.triggers WHERE parent_class=0

Well, the problem is that some of our instances of 2008 have been experiencing an issue where WMI use just stops working correctly for some reason and the only thing...

I don't think there is a way to find out WHO created it, but you can see WHEN it was created:

select

crdate,

i.name,

object_name(o.id)

from

sysindexes i

join sysobjects o ON o.id =...

I thought of this as well, but I think because this is a Development box, we have a lot of people setup as sysadmins who need access to drop/create/alter objects...

OK, so know I have a DDL trigger that logs all events, a DDL trigger to prevent this specific table from being dropped, and a normal table trigger to prevent...

Well, the reason I am worrying about this one specific table being dropped is because it is used to store information from another DDL trigger we have setup on the...

Thanks for the quick response. This is exactly what I needed and it works perfectly. 🙂

Thanks for sharing this script. It works great and is going to be a big help in the future.

What I am basically trying to do is send a CSV file with records from 3 different tables. I know I can just do it by creating 3...

Thanks for the help everyone. I ended up going with a UDF that parsed the string into individual rows in a temp table, then I just did a...

Try creating another variable for the body, then forming a string that includes the variables you need:

Declare @Body VARCHAR(500)

Set @Body = "This is a test:' + @variable + ' More...

When it comes down to it, the reason the tempdb fills up is because the query is returning way too much data, and you need to find out why and...