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

[hamtaro^-^]

Hi guys

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

Thanks any help will be well appreciated.

[GaryMazzone]

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


DISABLE TRIGGER Schema.TriggerName ON Schema.TableName;

[mendhak]

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

[mendhak]

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

[hamtaro^-^]

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