Doh! That works. Thank you. 🙂

Hmm, it's not showing anything.

I can see from the error log, a login failure every 60 seconds. I've been running profiler & can see absolutely nothing to correspond with...

Thanks, appreciate the response. I'll give it a go now.

thanks guys. appreciate your time. i'll have a look @ those options now.

By which I mean I'm prevented by standard operating procs here ... not that there's a technical issue in doing so.

Thanks, but I can't use cmdshell - frustrating I know!

Thanks my dears!! Much obliged. 😀

Thank you!!

That's perfect, now I just need to add in a distinct & convert into the format '20 Dec 2009'.

:unsure:

I'm being a muppet with this i know.