SQL Script to delete stranded activity for a specific user
Hi all In this article I am providing a script to delete the activity table records for a specific stranded user in Dynamics GP. This will enable us not to have all the users log out of GP in order to execute these scripts. This is typically handy when we have many users signed into [...]
May 16, 2010 · 
veeyeskay · 
5 Comments
Tags: ACTIVITY, DEX_LOCK, DEX_SESSION, DYNAMICS database, Stranded User, SY00800, SY00801, User Activity · Posted in: Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, System Total Views: 1,440