Results 1 to 7 of 7

Thread: running .NET application from SQL

Hybrid View

  1. #1
    Join Date
    Oct 2003
    Posts
    3

    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

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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

  3. #3
    Join Date
    Oct 2003
    Posts
    3
    the application runs through the database and sends confirmation emails to all the email addresses in the database. Then it deletes these records.

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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

  6. #6
    Join Date
    Oct 2003
    Posts
    3
    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?

  7. #7
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •