Home > Archive > MS SQL Server > March 2006 > delete triggers









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author delete triggers
mecn

2006-03-30, 8:23 pm

Hi,, How do i delete all triggers in one database? Quick way.

Thanks


Joe D

2006-03-30, 8:23 pm

I think you could use the new 'SQL Server Management Studio' to highlight as
many triggers you wanted, right click and select delete. I know you can with
Embarcadero's DBArtisan tool.

hth


"mecn" <mecn2002@yahoo.com> wrote in message
news:O9pIpnDVGHA.5148@TK2MSFTNGP12.phx.gbl...
> Hi,, How do i delete all triggers in one database? Quick way.
>
> Thanks
>



mecn

2006-03-30, 8:23 pm

Thanks

"Joe D" <jkdriscoll@qg.com> wrote in message
news:e0hhli$177l$1@s
xnews1.qg.com...
>I think you could use the new 'SQL Server Management Studio' to highlight
>as many triggers you wanted, right click and select delete. I know you can
>with Embarcadero's DBArtisan tool.
>
> hth
>
>
> "mecn" <mecn2002@yahoo.com> wrote in message
> news:O9pIpnDVGHA.5148@TK2MSFTNGP12.phx.gbl...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com