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
Dynamics GP Security Smart lists
Most of our clients wanted to review their Dynamics GP security setting using smart list, so we have setup some smart list’s using smart list builder. Here is the list Sr.
April 28, 2010 · · No Comments
Tags: ACTIVITY, builder-import, class-master, details, dynamics, Dynamics GP, modification, modified-group, reports, requirements, tools, users-as-well, using-smart, your-dynamics · Posted in: Blogs I Follow Total Views: 150