[p]Thanks yaar.. good question..
To disable..
[/p]
DISABLE TRIGGER Person.uAddress ON Person.Address;
GO
[p]And to Enable triggers, we can use this query.. [/p]
ENABLE Trigger Person.uAddress ON Person.Address;
GO
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha