>My VFP application has some shared free tables that are used in numerous Client DBCs. The DBC tables have foreign keys from these free tables. How can this be implemented in SQLServer. Can I set up a Common database and place the primary key into other DB's tables?
Hi Mike,
You can but you have to keep in mind following consequences:
You'll have to give users access to the Common database, even if you're using stored procedures
The built-in Referential integrity works in database only. You'll have to use triggers to enforce cross-database referential integrity
--sb--