Invoke .NET program from SQL SERVER SP / TRIGGER

[3DDD]

I need to call a Visual Basic .NET object when a specific event happens in SQL Server. I can capture this event through an INSERT trigger on a table, but how do I call the Visual Basic .NET object from the trigger?

Any Ideas???

 

[Dimandja]

You can Shell the .NET program, like this, for instance:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp

Launching a program that has a user interface will not work.

 

[3DDD]

Thanks!