正如Mark提到的那样,先前的声明应该以半殖民地的形式结束。 因此,你可以使用:

; DISABLE TRIGGER dbo.tr_name ON dbo.table_name

ENABLE TRIGERT OR DISABLE TRIGERT in a new line written GO, Example:

DISABLE TRIGGER dbo.tr_name ON dbo.table_name

GO
-- some update statement

ENABLE TRIGGER dbo.tr_name  ON dbo.table_name

GO

下面是动态的文字,能够使Triggers或使其失效。

select  alter table  + (select Schema_name(schema_id) from sys.objects o 
where o.object_id = parent_id) +  . +object_name(parent_id) +   ENABLE TRIGGER  +
Name as EnableScript,*
from sys.triggers t 
where is_disabled = 1

我想分享有助于我的发言。 理想的信贷是@Siavash和@Shahab Naseer。

我需要的是,我可以描述某些表格的可描述性,并重新使触发因素成为可能。 我通常试图避开夸大,但有时会善于使用。

我拿上上述文字,并加入一对硫磷,因此我可以按表名过滤。 该书将排除一个触发点或触发表。

select  alter table  + (select Schema_name(schema_id) from sys.objects o 
where o.object_id = parent_id) +  . +object_name(parent_id) +   ENABLE TRIGGER  + t.Name as EnableScript,*
from sys.triggers t 
INNER JOIN dbo.sysobjects DS ON DS.id = t.parent_id 
where is_disabled = 0 AND DS.name =  tblSubContact 

如果你想要执行ENABLE TRIGERT 直接来源:

我们可以这样说:

Conn.Execute "ENABLE TRIGGER trigger_name ON table_name"

相反,我们可以写:

Conn.Execute "ALTER TABLE table_name DISABLE TRIGGER trigger_name"

USE [DatabaseName]
GO

-- HABILITAR TRIGGERS
SELECT  ALTER TABLE [ + 
    ( SELECT SCHEMA_NAME(SCHEMA_ID) FROM [sys].[objects] AS O WHERE O.[object_id] = T.[parent_id]) 
        +  ].[  + OBJECT_NAME(T.[parent_id]) +  ] ENABLE TRIGGER  + T.[name] +  ;  AS [EnableScript], *
        FROM [sys].[triggers] AS T 
            INNER JOIN [sys].[sysobjects] DS ON DS.[id] = T.[parent_id]
        WHERE T.[is_disabled] = 0 
            --AND DS.[name] =  TableName 

-- DESHABILITAR TRIGGERS
SELECT  ALTER TABLE [ + 
    ( SELECT SCHEMA_NAME(SCHEMA_ID) FROM [sys].[objects] AS O WHERE O.[object_id] = T.[parent_id]) 
        +  ].[  + OBJECT_NAME(T.[parent_id]) +  ] DISABLE TRIGGER  + T.[name] +  ;  AS [EnableScript], *
        FROM [sys].[triggers] AS T 
            INNER JOIN [sys].[sysobjects] DS ON DS.[id] = T.[parent_id]
        WHERE T.[is_disabled] = 0 
            --AND DS.[name] =  TableName 

-- HABILITAR TRIGGERS SELECT ALTER TABLE [ + ( SELECT SCHEMA_NAME(SCHEMA_ID) FROM [sys].[objects] AS O WHERE O.[object_id] = T.[parent_id]) + ].[ + OBJECT_NAME(T.[parent_id]) + ] ENABLE TRIGGER + T.[name] + ; AS [EnableScript], * FROM [sys].[triggers] AS T INNER JOIN [sys].[sysobjects] DS ON DS.[id] = T.[parent_id] WHERE T.[is_disabled] = 1 -- Must be 1, not 0 -- --AND DS.[name] = TableName

亚洲国家:

Pinned: Currently used. Clean: Meaning the buffer is now unpinned and is a candidate for immediate aging out if the current (data blocks) are not referenced again. The contents are either in synch with disk or the buffer contains a CR snapshot of a block. Free/Unused: Meaning the buffer is empty because the instance just started. This state is very similar to Clean, except that the buffer has not been used. Dirty: Buffer is no longer pinned but the contents (data block) have changed and must be flushed to disk by DBWn before it can be aged out. Three Buffer Pool:

Keep Recycle Default Database Buffer Cache Parameter:

DB_CACHE_SIZE (BLOCK SIZE will be the size declare in DB_BLOCK_SIZE) DB_KEEP_CACHE_SIZE DB_2K_CACHE_SIZE DB_4K_CACHE_SIZE DB_8K_CACHE_SIZE DB_16K_CACHE_SIZE DB_32K_CACHE_SIZE DB_RACYCLE_CACHE_SIZE DB_BLOCK_SIZE(Default Block size which can not be changed later anyway)

SHOW PARAMETER DB_BLOCK_SIZE;

a. 显示参数db-cache_size;

以下是最简单的方式:

守则

<代码>ALTER TRIGERTstart_name DISABLE

......