Create SQL2005 trigger from C# form

[sandi]

Please Advice...

I need to create SqlServer2005 trigger from C# form. so all my trigger
can re-create if i push one button on my app.... i need to know how i
create and delete trigger from c# form and how to check if the trigger
already exist

regards

Sandi Antono

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
You can do it by using DM-SQL , do this. go to the interprise manager of
SQL and select the DB you want, right click, all taks, generate sql script,
select generate drop & create and also the one for triggers.

you will get a script that will recreate your DB, you can check the script
and see how he does it, it's very interesting if you have never done it.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
<sa***@e-axioma.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .

Please Advice...

I need to create SqlServer2005 trigger from C# form. so all my trigger
can re-create if i push one button on my app.... i need to know how i
create and delete trigger from c# form and how to check if the trigger
already exist

regards

Sandi Antono