topic Unable to detach geodatabase from ArcSDE without closing and reopening ArcCatalog in Data Management Questions

Unable to detach geodatabase from ArcSDE without closing and reopening ArcCatalog

WilliamKirchhoff — Wed, 30 Jan 2013 17:10:23 GMT

All,

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.

Re: Unable to detach geodatabase from ArcSDE without closing and reopening ArcCatalog

ShannonShields — Mon, 04 Feb 2013 19:55:00 GMT

What version of ArcGIS are you using? There has been a fix to address this issue - I'd have to check to see exactly which version it is in.

-Shannon

Re: Unable to detach geodatabase from ArcSDE without closing and reopening ArcCatalog

WilliamKirchhoff — Mon, 18 Feb 2013 15:17:02 GMT

Shannon,

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.