GP-DYNAMICS
 
 Custom Programming
Home
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 http://www.gp-dynamics.com/mssql-deep-search.asp



IMPORTANT:
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: 7478 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 138
Levitra Vendita Comprare Propecia Acquisto Female Viagra Acquisto Cialis Jelly Viagra Super Active Levitra Originale Viagra online Levitra Compresse Divisibili Disfunzione Erettile Ecografia Comprare Priligy Viagra Generico Comprare Brand Cialis Kamagra Oral Jelly Viagra Originale 100mg Acquisto Kamagra Flavored Propecia Generico Comprare Levitra Comprare Viagra Jelly
lunette soleil chaussure femme nike roshe Air max nike lunette soleil carrea nike air force nike chaussure adidas yeezy chaussure new balance lunette soleil oakley nike huarache Chaussure asics nike air huarache adidas stan smith nike free nike presto chaussures sport chaussure converse Air max casquette
nike shox nike air max mujer joyas tiffany nike huarache polo ralph lauren Zapatillas adidas air max zapatos louis vuitton Adidas Superstar Zapatos adidas zapatos christian louboutin bolsos michael kors nike air max nike roshe
nike shox hogan scarpe calcio Tiffany christian louboutin Scarpe Adidas superstar Scarpe Reebok Adidas Scarpe nike sb Scarpe nike air force air jordan adidas scarpe Tacchi

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.