Create SQL2005 trigger from C# form

  • Thread starter Thread starter sandi
  • Start date Start date
S

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
 
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.
 
Back
Top