RSMUS.comFavorite SQL Scripts
These are my most commonly used SQL scripts on every Microsoft Dynamics GP implementation that I perform, now compiled in one place.
One caveat, always, always, always have a RESTORABLE backup, in case something undesirable occurs and try this on a test server or test company first. Please use these queries with caution. IMPORTANT: Commands with UPDATE, DELETE or DROP can ruin your data! I have remarked those commands out as a further precaution, so they are not run inadvertently with the Select statements.
So here they are in no particular order: (Imagine a drum roll at this point!)
User Activity
Batch Stuck
Find Tables based on Field Name
Grant SQL
So those are some of my most useful scripts. Please leave a comment and let me know some of yours.
Want to know more about working with Microsoft Dynamics GP? Contact our Dynamics experts 855-437-7201
by Danielle Edie for RSM
RSM Staff
RSM empowers middle market companies worldwide to take charge of change. Our unique middle market perspective makes RSM the natural choice for growth-oriented, internationally active organizations seeking relevant insights and tailored, innovative solutions for a complex and changing world. With a global reach spanning more than 120 countries, we instill confidence in a world of change by bringing the full power of RSM to make a lasting impact on our clients, colleagues and communities.