From C/Side to MS SQL

Hi,

Actually under C/Side when I want to query data I can only do it one company at a time through different DSN (ODBC), I was wondering if it is the same for MS SQL, would different company’s be stored in different database or will I be able to access all of them in one shot?

Tks

Nicolas

Yes. Each company will have its own table.

CompanyA$Item

CompanyB$Item.