How to enable/disable Triiger in SQL2005 Using C# code

Hi guys

Any idea on how can I enable/disable Triiger in SQL2005 Using C# code?

Thanks any help will be well appreciated.

You use SQL command then pass to the DB using a connection and command oject. Use ExecuteNonQuery


DISABLE TRIGGER Schema.TriggerName ON Schema.TableName;

You could also look at DatabaseDdlTrigger
http://technet.microsoft.com/en-us/l...r(SQL.90).aspx

You could also look at DatabaseDdlTrigger
http://technet.microsoft.com/en-us/l...r(SQL.90).aspx

yup thanks i already figured it out...but anyways thanks for the reply