Hi folks,
I'm designing an sql server 2005 database to hold accounting
information of a given company (ies). The database containg a table for
EmployeeAccounts which in turn should be somehow related to the
aspnet_Users table of aspnetdb table to handle the A&A (Authentication
and Authorization) of an employee within the system.
The question is that how am I supposed to link these 2 tables, say,
EmployeeAccounts an the aspnet_Users? Of course, I could create the
membership database (aspnetdb) within my accounting database using the
aspnet_regsql utility, however, I'm not sure which one is the preferred
way.
Any help would be highly appreciated,
Thanks in advance.
Mehdi