hi...

i have web app with sql database.

i sell my app to diffrent customers.

now i have one customer that he want to buy 2 app (app1&db1----app2&db2)...it's well. but my problem is here that:

i have Emp table in my database that store Employee information.

for this customer  i need 2 database for 2 app but i need the  Emp table be the same in 2 database.

i search diffrent solutin and i need some help to use best solution:

1- using trigger to sync 2 tbl in 2 database==> it's not good becuse data in Emp tbl are too many and storing these data in 2 place is not googd suggestion.is't it?

2- access the Emp tbl data in only 1 database(using lnked server in sql server) ==> in this way i shuold change lots of my code...

i'm looking for a solution that i can have virtual table in db2 that is pointer to the Emp.db1!!!

is it possible?

any suggestion plz?