— Query to check for any database triggers in a Database
SELECT
t.name,
t.is_disabled,
te.type_desc AS trigger_event
FROM sys.triggers t
JOIN sys.trigger_events te ON t.object_id = te.object_id
WHERE t.parent_class_desc = ‘DATABASE’;

–If found they can be disabled/enabled with:
/*
USE [Admin]
go
DISABLE TRIGGER tr_MStran_alterschemaonly ON DATABASE;
GO
USE [Admin]
go
ENABLE TRIGGER tr_MStran_alterschemaonly ON DATABASE;
GO
*/