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.