topic Re: kill locks without sdemon using direct connects in Data Management Questions https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548664#M31087 <HTML><HEAD></HEAD><BODY><P>mark the thread as answered maybe <IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Wed, 24 Sep 2014 19:53:07 GMT AsrujitSengupta 2014-09-24T19:53:07Z kill locks without sdemon using direct connects https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548661#M31084 <HTML><HEAD></HEAD><BODY><P>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.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>We are running 2-tiered architecture using only direct connects, dbo schema on arcgis 10.2.1, sql server 2008 R2.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>thanks, </P><P>sp</P></BODY></HTML> Tue, 23 Sep 2014 21:42:10 GMT https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548661#M31084 deleted-user-AzQ5lcTQbS2a 2014-09-23T21:42:10Z Re: kill locks without sdemon using direct connects https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548662#M31085 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>DisconnectUser (arcpy):</P><P><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000061000000" title="http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000061000000">ArcGIS Help (10.2, 10.2.1, and 10.2.2)</A> </P></BODY></HTML> Wed, 24 Sep 2014 04:16:45 GMT https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548662#M31085 AsrujitSengupta 2014-09-24T04:16:45Z Re: kill locks without sdemon using direct connects https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548663#M31086 <HTML><HEAD></HEAD><BODY><P>thanks, genius! <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 24 Sep 2014 19:36:48 GMT https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548663#M31086 deleted-user-AzQ5lcTQbS2a 2014-09-24T19:36:48Z Re: kill locks without sdemon using direct connects https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548664#M31087 <HTML><HEAD></HEAD><BODY><P>mark the thread as answered maybe <IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Wed, 24 Sep 2014 19:53:07 GMT https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548664#M31087 AsrujitSengupta 2014-09-24T19:53:07Z Re: kill locks without sdemon using direct connects https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548665#M31088 <HTML><HEAD></HEAD><BODY><P>I was working on it... that took waaaay too long to find.</P><P>That option isn't available when viewing/communicating through the inbox.&nbsp; You literally have to open the thread separately. Still learning.&nbsp; Thanks for the assistance!</P></BODY></HTML> Wed, 24 Sep 2014 20:03:44 GMT https://community.esri.com/t5/data-management-questions/kill-locks-without-sdemon-using-direct-connects/m-p/548665#M31088 deleted-user-AzQ5lcTQbS2a 2014-09-24T20:03:44Z