Post reply

Queries

  • November 16, 2003 at 11:34 pm

    #84741

    How can i explicitly execute a trigger ?

    Tigger gets executed when an event like Insert/Delete/Update is executed...i need to fire a trigger from Stored Procedure without executing an insert/delete/update statement

    How can i do this ?

  • November 17, 2003 at 6:38 am

    #482194

    I wonder what is that u want to do in a trigger on a table without executing Insert/Delete/Update queries???

    What u can do is write a stored procedure and call this sp from the trigger and/or another sp. (I guess u r not using the inserted and deleted tables in the trigger)

    Sachin


    Regards,
    Sachin Dedhia

  • November 17, 2003 at 7:01 am

    #482202

    What are you trying to do?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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