kill locks without sdemon using direct connects

3707
4
Jump to solution
09-23-2014 02:42 PM
deleted-user-AzQ5lcTQbS2a
New Contributor III

Is there a way to script or .bat something that will kill locks on a database prior to geoprocessing? I couldn't get sdemon to work from another computer using both the instance sysadmin user or the dbo, and I don't anticipate installing sde tools on our 10.2 infrastructure to begin with.

 

We are running 2-tiered architecture using only direct connects, dbo schema on arcgis 10.2.1, sql server 2008 R2.

 

thanks,

sp

0 Kudos
1 Solution

Accepted Solutions
AsrujitSengupta
Regular Contributor III
4 Replies
AsrujitSengupta
Regular Contributor III

Try this:

DisconnectUser (arcpy):

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

deleted-user-AzQ5lcTQbS2a
New Contributor III

thanks, genius!

AsrujitSengupta
Regular Contributor III

mark the thread as answered maybe

0 Kudos
deleted-user-AzQ5lcTQbS2a
New Contributor III

I was working on it... that took waaaay too long to find.

That option isn't available when viewing/communicating through the inbox.  You literally have to open the thread separately. Still learning.  Thanks for the assistance!