running .NET application from SQL

I have an .NET application I want to run when data is entered into a database.
Is there a way to have it execute automatically?

Thanks
Ray

what that .NET (I believe its VB.net or C#) do?

Why cant you create a DTS package which does the same functionality.

refer www.sqldts.com

the application runs through the database and sends confirmation emails to all the email addresses in the database. Then it deletes these records.

can the application can be fired from a command prompt or batch file?

if so then you can do using XP_Cmdshell or using DTS package or using Activex Wscript

email can be sent using xp_sendmail or using smtpsend or cdosys email.

if you know which table is having the data then you could create a trigger which can be fired on every insert

we were going to use xp_sendmail, but to do so a mail application (we use Outlook) has to be loaded onto the server, and it's our policy not to put that on our servers so they aren't opened up to virus attacks through email.

we are going to try it using xp_cmdshell, but in past variations of this project we tried to use do that with a vbscript file and doing so cause SQL Server 2000 to stop on that server. We had to reboot the server to get it back. The vbscript worked when run by double-clicking it, but putting xp_cmdshell in a trigger on the table that's updated blew up SQL Server 2000.

any suggestions?

SMTPSEND or CDOSYS

http://forums.databasejournal.com/sh...highlight=SMTP