Thanks for the replies.

It's the parenthesis mainly that's the problem - the actual query, and structure are the same (given the small changes you've mentioned in functions), but it's Access...

Hi - at what stage should you be worried that the temo DB is too big?

My main database returns a log space used of 43.143139% - should I be doing...

Hi - thank you.

I'm not familiar with this - are theer examples which demonstrate hjow to implement anywhere?

Thanks, Mark

Hi - thank you, I wasn't aware there was another version - I'm presuming I have V1.0 - is there a way I can tell? Also, does V2 have...

Hi - MSDE is creaking (imo) because in the event logs I see the 'exceeded 8 concurrent connections' too many times.  The site is not busy yet either!  What I...

Hi Ian - thank you I'll search in there.

The site is .Net - so all of the hits are directly from the compiled dll.

Kind regards, Mark

Hi Frank - AutoClose and AutoShrink are both ticked.

I can't see any more options for AutoClose though.

Kind regards, Mark

Ignore me - I wasn't overloading in the tests enough for them to register in the logs (I'm looking for the 8 concurrent message in MSDE).

Thanks, Mark

Hi - Thank you.

Only reason I was using a Job was because I'm using XP_SMTP_MAIL dll (as I don't have MAPI/Outlook) - and I think this is the only method...

Hi Frank - yes it would - it seems to have good feedback in the forums too.

Thanks for your help,

Kind regards, Mark

Hi Frank - yes I did look in Master too - and they're not there.  I thought it may have been because I was using MSDE 2000.

Thanks, Mark