Points: 54175

8/22/2012 8:52:06 AM

Dynamics - Find Dynamics Users that do not have a database login

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

Here's a nice little script sent in by Tonya from AceMicrotech; it will give you the name of the Dynamics users that don't have a corresponding SQL login - the kind of thing that might happen if you're migrating servers or have an 'incident' in the SQL security panel. <smiles>
Version: GP 2010
Section: Dynamics GP,SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables