Hi Rudy,

Thanks for the reply and suggestions,

We haven't tried sp_who2 yet but it is on our list of actions for next time it happens.

Will try sp_lock too.

Cheers, Nathan

oh yeah and as far as backup go for MySQL, that is easy. For MyISAM tables you just copy the files.

innoDB tables you can backup in the same way, but...

I've used MySQL/PHP quite extensively in prev jobs and in my current position am using more SQL Server/ASP.

In my opinion, MySQL can handle large datasets no worries - my last...