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

    Sql server help


    is there any sort of object in sql server that starts a thread or procedure in
    i want as soon as a new record is entered in database...a procedure in 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.

    I hope this will help you out.

    Mohit Jain

    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.