I think you're making the problem a little more complicated than it needs to be. Check out one-to-one relationships. That should enable you to enforce referential integrity between the tables. The only thing you'd need to add logic to enforce is having a record in the Person table if and only if the EntityType is "Person." And similarly for each of the other entity types. Even that isn't entirely necessary, if you'd rather put logic into your views and stored procedures to make different joins based on the EntityType (a little tricky, but hardly impossible).

No, I`ve uninstalled it before. ;) I`ve cleaned up the registry of any information regarding this service and it doesn`t exists on the HDD either. I`ve changed the product and upgrade code and still nothing. I have administrative rights, I even give miself rights to act as a part of the operating sistem ;P. The entry in the Application log is: The description for Event ID ( 11001 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Product: FaxManagementServices -- Error 1001. Access is denied. , (NULL), (NULL), (NULL), (NULL), (NULL), (NULL). I`ve activated the security audit and apparenty there is not an authentication faliure during the install process.

I wish I could help you. I looked all over the place for this and came up dry. We're eventually going to get something like InstallShield which I hope will provide the functionality. I did find a way to hack the registry to check the checkbox but it still didn't behave like I checked it manually. I had to uncheck it, apply, then recheck it. If you ever do figure this out, please let me know (I'll keep looking).