Hi,
I have 2 SQL-Server apps that use ID fields to separate out 'sub areas' of the database like your multiple companies. These fields can be applied invisibly to the user, as the user logs in from a pre-defined company. All transactions simply have the correct company code added to new records.
One client considered using multiple databases, but because SQL-Server handles large amounts of data smoothly, we found it much easier to use a single database and simply include the ID codes.
HTH
Barbara
>Hi all,
> I am going to develop an applicaction use SQL SERVER Backend that was intended to bemulti-company or with different data sets,How do I better way?
>
>1. Design a company ID field in the table of the database and then filter on all
>transactions based on that ID ?
>2.Can DQL SERVER separate location collectd data for eacs company?
>3. I will like that experienced people give me advise about it. Has anyone
>worked with this ?
>
>Thanksin advance,
>Regards
>
>Sanit kiriwong.