http://blogs.msdn.com/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspxFrom the Useful SQL Scripts Series . When a system has a batch that is stuck as marked to post or a transaction that cannot be accessed as it says it is already being edited, the usual instructions are to exit all users from the system and then deleteen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx#9162579Tue, 02 Dec 2008 05:00:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:9162579David Musgrave<p>Posting from the Dynamics GP Blogster</p> <p><a rel="nofollow" target="_new" href="http://dynamicsgpblogster.blogspot.com/2008/12/sql-mania-series-at-developing-for.html">http://dynamicsgpblogster.blogspot.com/2008/12/sql-mania-series-at-developing-for.html</a></p> http://blogs.msdn.com/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx#9169361Wed, 03 Dec 2008 13:25:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:9169361Andrew Cooper<p>This is an extremely useful script.</p> <p>I would propose one amendment however - that the &quot;?&quot; in &quot;use ?&quot; is enclosed in square-braces, as per &quot;use [?]&quot;.</p> <p>This ensures that databases with hyphens in the name are handled correctly.</p> <p>Other than that, another high-quality and well written post!</p>http://blogs.msdn.com/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx#9173597Thu, 04 Dec 2008 08:30:52 GMT91d46819-8472-40ad-a661-2c78acb4018c:9173597Samuel Mathew<P>This is a great article and a very useful script for all the technical consultants who directly support their customers. </P> <P>We come across these type of issues very often with our customers.</P> <P>Thanks to David.</P>http://blogs.msdn.com/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx#9192124Wed, 10 Dec 2008 22:33:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:9192124US Microsoft Dynamics GP Field Team<p>Based on the success of the &quot;Resolving Security Issues in Dynamics GP&quot; located here, Microsoft Dynamics</p> http://blogs.msdn.com/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx#9194230Thu, 11 Dec 2008 05:05:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:9194230Microsoft Dynamics GP US Field Team blog <p>Based on the success of the &amp;quot;Resolving Security Issues in Dynamics GP&amp;quot; located here, Microsoft</p> http://blogs.msdn.com/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx#9440736Mon, 23 Feb 2009 02:52:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:9440736David Musgrave<p>Posting on Rose Business Solutions Blog</p> <p><a rel="nofollow" target="_new" href="http://rbsgp.blogspot.com/2009/02/dynamics-gp-top-technical-support.html">http://rbsgp.blogspot.com/2009/02/dynamics-gp-top-technical-support.html</a></p>