A little thread drift:

I know you can alter the timeout value for a particular database.

Can someone confirm if it is possible to change the default for all mirrored dbs (including...

Hiya Hemant.R

No sure what you mean by

please can u check with application team ,how many user connection they have mention in application.

if that exceed problem will arise.

Profiler indicates connections...

again, apologies, I did preface this twice by saying it was SQL 2000.

Now that I've found the 2000 forum I shall move/delete this.... if I can

Thanks for your observations

Thank you but that behaviour, I believe, applies to SQL 2005 on. My scenario is for SQL 2000.