>The db_ddladmin role rights should be enough to drop a trigger.
>You don't have to drop triggers but can disable them.

>-- Disable all triggers
>ALTER TABLE tablename DISABLE TRIGGER ALL
>...
>ALTER TABLE tablename ENABLE TRIGGER ALL
>-- specific trigger
>ALTER TABLE tablename DISABLE TRIGGER triggername
>...
>ALTER TABLE tablename ENABLE TRIGGER triggername
>

I switched over to your idea. Thanks.

It worked better when I changed the server in the app.config. For the longest time I was pointing to Prod, and making all kinds of changes in dev.

Bad Steve!