When I try to detach a geodatabase from my ArcSDE SQL Server Express instance get an error stating the geodatabase is in use -which it is not. If I close ArcCatalog and reopen it I can then go ahead and detach the geodatabase. Doable, but a pain - anyone know of a way around this? Thanks.
Sorry to take so long to get back to you, thanks for the reply. I'm using ArcGIS 10.0, Service Pack 5 on a Win 7 workstation. I have an ArcInfo level license. I have administrator permission to the SQL Server Express Ed. w/ Advanced Services - ArcSDE Personal Server version 10.0.5500.0. While my initial problem was with ArcCatalog, I have also noticed that I am unable to manage geodatabases using ArcObjects. The 4GB limitation imposed on SQL Server Express means I have to swap out geodatabases regularly. I have attempted to do this programmatically using the IDataServerManagerAdmin.DetachGeodatabase method, but I get the same response - the error message effectively tells me that someone else is connected to the geodatabase, even though there is no one else on the system. 0x80040E14 HRESULT = -2147217900, which I believe leads me to geodatabase extension code, but there is no specific error code listed for this value. Appreciate any help you can offer.