Custom Programming
Dynamics TechBrief
MSSQL Deepsearch

How these can help you

How to purchase

Free Dynamics GP Sql Scripts


Collection of Useful Microsoft Dynamics GP Sql Scripts, Tips and Tricks

A nifty way to reverse engineer data manipulation in MS GREAT PLAINS applications

Long Description:
** This is a sponsored post from GP-DYNAMICS.COM**

Helpful Tip for MICROSOFT GREAT PLAINS developers and/or programmers:

Most of the time, our requirements as developers revolve around pulling rows of data by querying the fields or columns of a known table. It's easy right?

But what if what you have are the literal values or data in a database but you don't know what tables and columns they are stored in? This is a typical scenario when developing add-on modules to an existing application such as Microsoft Great Plains Applications. What is the best way to sort of reverse engineer the data flow in these programs so you can pinpoint the actual database objects that you will manipulate on your custom modules?

MSSQL DEEPSEARCH is a very handy utility program that will scan an entire database and give you the exact table and column names that hold a particular literal value that you entered. You basically just provide the connection parameters to any MSSSQL database and it will do the rest for you.

Try it, it's called MSSQL DEEPSEARCH. A demo version is available for download at

Commands with UPDATE, DELETE or DROP can ruin your data! Please use these queries with caution. We highly recommend that you backup your database before trying out these commands and to load them up first on a test server. Use at your own risk.

Associated SQL Command:

Viewed: 9601 times

Submitted by: GP-Dynamics

About GP-Dynamics

View complete list previous script
next script

Did you find this script useful?
Please reciprocate by submitting your own script
or any proven advice regarding Dynamics GP use. Click here.


Send the script above to a friend

Send to EMAIL: *

Short MESSAGE: *

Sender NAME: *

Sender EMAIL:

Validation code: *  Enter 230

Trademarks: Microsoft™, Microsoft Dynamics™ and/or Microsoft logos, products, and services referenced in this site are either trademarks or registered trademarks of Microsoft Corporation.

Disclaimer: This product is not officially endorsed by Microsoft. Furthermore, this website does not imply representation of Dynamics™ or relationship with Microsoft in any form.