Hi Tom I am not sure but try executing this query using your favourite SQL query browser
SELECT T.[name] as TableName, TR.[Name] as TriggerName,
CASE WHEN 1=OBJECTPROPERTY(TR.[id], 'ExecIsTriggerDisabled')THEN 'Disabled' ELSE 'Enabled' END Status
FROM sysobjects T INNER JOIN sysobjects TR on t.[ID] = TR.parent_obj WHERE (T.xtype = 'U' or T.XType = 'V')
AND (TR.xtype = 'TR') ORDER BY T.[name], TR.[name]
this should give you a list of the triggers in your DB and their status.
if the query is ok then you can use java to play with the result and do your busniss logic. for example if they are all disabled then it means that triggers are disabbled.
hope it helps
Omar Al Kababji - Electrical & Computer Engineer
[SCJP - 90% - Story] [SCWCD - 94% - Story] [SCBCD - 80% - Story] | My Blog
Joined: Nov 01, 2004
thank you for the solution. I think that select query would be very helpful.