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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>