>The app I'm working on uses VFP triggers to allow or prevent changes based on the existance of a particular object to ensure the changes are being made thru the system (don't start me on the wisdom of that...I inherited this mess). We are trying to migrate the system to use SQL Server 7.0 as the back end, and the powers-that-beat want to carry over this design "feature".
>
>Unfortunately nothing comes immediately to mind. We have already build a class that passes changes to SQL directly. It wouldn't be too difficult to create a middle-tier COM object to handle data changes, but can a SQL Server trigger communicate with an external object? Anyone have any suggestions on how to do this?

Daniel,

You can call xp_cmdshell (not sure if it is exact name) from a stored procedure. You can probably do it from a trigger but haven't tried that one. The user context needs to have access to this extended sp from the master db.