Re-Enable All Triggers in SQL Server

Hello to everyone,

In this article, I will try to give information about how to reactivate all Triggers in SQL Server.

In SQL Server you may want to re-enable all Triggers in some cases.

You can easily do this using the code below.

EXEC sp_MSforeachtable 'ALTER TABLE ? ENABLE TRIGGER ALL';

You can re-enable all triggers by running this code.

Good luck to everyone in business and life.

62 Views

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!