You must Sign In to post a response.
  • Category: ASP.NET

    Sql server help

    hi

    is there any sort of object in sql server that starts a thread or procedure in asp.net....
    i want as soon as a new record is entered in database...a procedure in asp.net is called
  • #348368
    hi juhee

    i don't think thr is any option in sql server like that
    u can use triggers to fire another sql queries.

  • #348431
    Hi Juhee,

    To achieve the same functionality you need to use CLR Stored Procedure or CLR Triggers, which allows to write your code in C# while it will be running in Sql Server. You can write your C# logic in this Trigger and deploy it in Sql Server, This trigger will be fired when a record will be inserted in the table and the logic written by you will be executed.

    http://msdn.microsoft.com/en-us/library/ms179562.aspx

    http://msdn.microsoft.com/en-us/library/ms131093.aspx

    http://aspalliance.com/1273_CLR_Triggers_for_SQL_Server_2005

    I hope this will help you out.

    Thanks,
    Mohit Jain

    Thanks,
    Mohit Jain
    MCTS, MCSD.Net, MCPD.Net
    Give a try, before telling No


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.