×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Additional fields and forms

How do I find tables/field in Dynamics by JonCross
Posted: 12 Dec 03

You can turn on a log of Dynamics SQL actions, do something in the area of interest in Dynamics then look at the log to see which tables have been accessed.

- Find file DEX.INI in you Dynamics directory
- Find the lines:
    SQLLogSQLStmt=FALSE
    SQLLogODBCMessages=FALSE
  and edit them to TRUE
- restart Dynamics and navigate to your area of interest
- In your dynamics directory delete DEXSQL.LOG (it will be quite big by now !)
- Change a field in the form you are interested in, then save the change.
- Look at the DEXSQL.LOG file
- BINGO !!

Make sure you edite the DEX.INI file entries back to FALSE else you will end up with a giant log file.


Jon

jon.cross@anite.com


Back to Microsoft: Dynamics GP (Great Plains) FAQ Index
Back to Microsoft: Dynamics GP (Great Plains) Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close