kill locks without sdemon using direct connects

[deleted-user-AzQ5lcTQbS2a]

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

[AsrujitSengupta · Accepted solution]

Try this:

DisconnectUser (arcpy):

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

[deleted-user-AzQ5lcTQbS2a]

thanks, genius!

[AsrujitSengupta]

mark the thread as answered maybe

[deleted-user-AzQ5lcTQbS2a]

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!