Hi,

I am using MSDE and getting some very inconsistent results. I have two functions I establish a connection to a MSDE Server (no initial catalog), after that I query a catalog for the tables using an OpenSchema method in the server using a separate connection a connection connected to the Catalog. This is properly closed, now with the original connection if I try to drop a catalog (not the one I was querying before using a DROP DATABASE SQL statement, it fails with a DB_E_ERRORSINCOMMAND. However if I wait about 2 minutes (entirely a guess I did not time it :)) the same procedure works fine. If I query another catalog straight after the drop then try drop another catalog it works straight away.

I have also noticed that when the error is occuring the request takes a long time to timeout (15 seconds or so, a long time in computer language).

It is as though after I query using OpenSchema the Server is locked for a little while from any drop commands. I perform other OpenSchemas asking for Tables on other catalogs fine but I cannot drop catalogs easily.

I am at a loss, any ideas.

Thanks in advance

KnNeeded