Post reply

get trigger information

  • July 18, 2008 at 5:15 am

    #71643

    Hi,

    I was trying to get information about the type of trigger but was not able to.

    I tried

    select * from dbo.sysobjects where xtype='TR'

    this trigger gives me the names of triggers, but how can i find the type of trigger such as (befor, after, instead of etc.)

    Thanx in anticipation.

  • July 18, 2008 at 5:23 am

    #844922

    As far as I know, the info about After/Instead of is just in the script of the trigger in SQL 2000.

    SQL doesn't have a before trigger

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 21, 2008 at 8:38 pm

    #846123

    select OBJECTPROPERTY ( id , 'ExecIsInsteadOfTrigger' ),

    OBJECTPROPERTY ( id , 'ExecIsAfterTrigger' ),

    OBJECTPROPERTY ( id , 'ExecIsInsertTrigger' ),

    * from dbo.sysobjects where xtype='TR'

    Check BOL for other OBJECTPROPERTY parameters.

    _____________
    Code for TallyGenerator

  • July 21, 2008 at 11:11 pm

    #846147

    Thanx.....

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

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