Yes, call sp_who, then KILL all the processes attached to your database ( thanks to whoever provided this solution, I asked this question only last week :-) ) Actually, that solves the problem in SQL Server. MySQL is kind of crap ( it doesn't even have stored procedures ), and in addition, sp_who is SQL Server specific, you'd need to find the equivelant in MySQL. Christian I have drunk the cool-aid and found it wan and bitter. - Chris Maunder