How to disable all triggers MS SQL Server

To disable all trigger

sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER all'

Or to enable or triggers

sp_msforeachtable 'ALTER TABLE ? ENABLE TRIGGER all'

Enable / Disable trigger in MS SQL server

DISABLE

ALTER TABLE table_name DISABLE TRIGGER tr_name

ENABLE
ALTER TABLE table_name ENABLE TRIGGER tr_name

SQL Server: Database stuck in “Restoring” state

RESTORE DATABASE MyDatabase
FROM DISK = 'MyDatabase.bak'
WITH REPLACE,RECOVERY