>> We are now creating an add-on product that keeps its data in sql server and plan to keep several companies in the same database with a Companies table that assigns a CompanyID for each company
>
>Hi Alejandro,
>
>A bug in your application -- unfortunately they happen -- may leak data belonging to one company to another company. Even if this seems to be an unlikely situation, you should consider it.
>
>E.g., if a company requests a backup of their data, you'll need to be sure that none else's data -- even inadvertently -- will get through.
>
>I would keep a separate database for each company. If this is not an option, at least keep companies under separate schemas. This will also allow you to separate access to data.

Hi Anatoliy, I appreciate your comment very much and will take it into account. It is still posible to keep companies in separate accounts.

Happy Holidays,

Alex