found a really dirty way to see if it is running :-

tasklist /svc | findstr "AGENT"

This seems to pick out the SQLAGENT job and if we then shut it down,...

thank you, you have given me some things to look into.

Thank you, that works a treat for what I need it for!

Thank you very much to both Jeff for the advice and Ken for a most brilliant script.

Thank you.

Now looked at the code, so that will keep me out of trouble for a little while!

Thank you, I have just extracted the code from sp_spaceused and will now spending a "happy" afternoon writing my own from it!

Luckily I think I have just found something in...

Thank you for replying so quickly and I thought it would be something like that but I am still having trouble, created a table and have tried what you suggest...

As I said in my opening gambit, it is going to be something simple and oh boy it was!

After some painful mail queue investigation I stopped and started Database Mail...

I checked and the profile has the public box ticked, it just is not the default profile.

I have another profile that also has the public box ticked and is default....