Dynamics GP Technical Database Guides – GP 10
Hi all In this article, I have posted the link of a detailed database reference guide for Microsoft Dynamics GP 10. I have posted the link to the guide for the system database (DYNAMICS) and the sample company (TWO) database. This guide provides detailed specifications of the various tables, views and stored procedures present in [...]
May 18, 2011 · 
veeyeskay · 
2 Comments
Tags: Database Guide, DYNAMICS database, TWO database · Posted in: Documentation, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 230
Dynamics GP Technical Database Guide –DYNAMICS Database
Hi all In this article, I have posted the link to my Christmas present to the community folks. This is a detailed database guide for Microsoft Dynamics GP. I have posted the link to the guide for the system database (DYNAMICS). The company database guide will follow. This guide provides detailed specifications of the [...]
December 27, 2010 · veeyeskay · 4 Comments
Tags: Database Guide, DYNAMICS database · Posted in: Dynamics, Great Plains, SQL Server 2005, System Total Views: 683
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