Table locations

[vertcnc]

Where are the data tables located at in version 8.0 mssql.
When I go to tools> and find the table descriptions it returns a list of tables. But when I go to the sql server database tw great plains databases are present "Dynamics" and "Companydata". The table names do not match the ones listed from the tolls menu. I trying to create a report within Crystal and would greatly appreciate some help.
Thanks

 

[jymm]

try running this code - it should tell you which company is what

use dynamics

select Interid, cmpnynam
from sy01500

This will give you the company names --- In the tools look at the PHYSICAL name --- that should be the table name within the DB

this help?

 

[vertcnc]

I am pretty much a newbie in sql. I have located the tables within the odbc connection within crystal reports. The table look close but they have some prefixes such as zd_sop10100_1.1. Then when i look at the fields in those tables they also have some additional Prefixes such as @.

Thanks Tim

 

[vertcnc]

Additionally when i look at the table via the sql server manager. They look identical to the tools> table descriptions. They only have the added charactors when viewing through the odbc connection.

 

[martink1]

in Crystal reports under 'file' 'options' find the tab that contains the check box for 'stored procedures' and make sure to uncheck it.

 

[vertcnc]

That did it. Thanks for the help.

Tim