Post reply

Notification on update

  • May 17, 2005 at 1:00 am

    #88408

    Could someone point me to tutorial (or outline the steps for me) on how to do the following:

    • I have an insert record form (aspx C#) based on sql server 2000 table
    • On insert of a new record, I want to trigger a notification to certain people that a new record has been added.

     

  • May 20, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • May 22, 2005 at 4:34 am

    #560399

    Hi James

    i think u can send notification like following

    create table t1 (sno int )

    go

    create trigger trgt1 on t1 for insert

    as

    exec master.dbo.xp_cmdshell 'net send tahir helllooooo'

    go

    insert into t1 values (2)

     

    tahir

    Kindest Regards,

    Tahir

  • May 22, 2005 at 7:10 am

    #560402

    James

    What kind of notification you want to send ? email or net send. As Tahir mention you can write trigger to do the job. Remember trigger comes with an overhead so make sure the table is not inserted very often. If you need to send the information about hte newly added row. Check the virtual table (inserted) IN THE TRIGGER

    Kindest Regards,

    Amit Lohia

  • May 22, 2005 at 7:45 am

    #560403

    Hi Amit,

    Given the following details could you please quickly put together a trigger to send the last added name. I plan to use xp_sendmail but still trying to configure the MAPI.

    UserID int 4

    UserName nvarcahar 50

    Password char 10

    EMailAddress nvarchar 50

    Table name = Users

    SQL Database = EUTSchedule

    Thanks in advance.

     

     

     

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply