SQL Server Performance

Triggers And Their Associated Tables

Discussion in 'Performance Tuning for DBAs' started by jwa, Jun 29, 2005.

  1. jwa New Member

    Other than using the OBJECTPROPERTY... is there another way to find out what the associated table is for a trigger from the sysobjects table?
  2. Adriaan New Member

    SELECT OBJECT_NAME(o.parent_obj)
    FROM dbo.sysobjects AS o
    WHERE o.xtype = 'TR' AND o.[name] = '<TriggerName>'
  3. jwa New Member

    Thank you so much! Worked perfectly.

Share This Page