25 lines
579 B
Transact-SQL
25 lines
579 B
Transact-SQL
--Migration
|
|
DECLARE @sql nvarchar(max) = ''
|
|
SELECT @sql += N'DROP TRIGGER IF EXISTS ' + name + char(13) + char(10)
|
|
FROM sys.triggers t WHERE OBJECT_NAME(t.parent_id) IN (
|
|
'T_ENTITYHISTORY',
|
|
'T_ENTITYATTRIBUTEHISTORY',
|
|
'T_LOG',
|
|
'T_GLOBALLOCK',
|
|
'T_OLDALLATOGATOTTSAG',
|
|
'T_FELHASZNALOBELEPESTORTENET',
|
|
'T_EVFOLYAMTIPUS_OKTATASINEVELE',
|
|
'T_TELEPULES',
|
|
'T_TANTARGYNEVHEZKATEGORIA',
|
|
'T_SERVERSTATISTICS',
|
|
'T_MOBILDBINFO',
|
|
'T_LOGLEVELTYPE',
|
|
'T_GLOBALISBEALLITASOK',
|
|
'T_INTEZMENY',
|
|
'T_FENNTARTO',
|
|
'T_LOGEVENTTYPE'
|
|
)
|
|
|
|
EXEC sp_executesql @sql
|
|
GO
|