Srijeet..I could make out what it is ..I found the triggers and also their status too.

This query helped me and thanks once agian..

Sreejit

Thanks for the reply . It worked but I did not understand why "is _disabled" is used ad the relevance of it...I tried with is_enabled in the...

I 'm sorry ... i noticed that i mistakenly posted it on 2005 topics but its about sql2000.

Murali