It is the language i was using - it was set to Brittish English

When i SET LANGUAGE 'English'

I didn't get the datetime conversion error and recived backup details in the...

Thinking about it.. it may be to do with the language i use. It was on my test machine. I'll try it when i get back to the office.

Thanks

First off - great article and a really handy stored procedure..

When i executed the sp i got this error message

Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72

An INSERT...

WTF???

There are some really useless and pointless questions on here sometimes... but this takes the biscuit!!

I thought the same....

Run

select objectproperty(object_id('sysobjects'), 'IsView')

and you'll see it's a view 🙁