Disable Triggers in SQL

1. May 2012 Anil Kumar MS-SQL Comments (0)

Two easiest command syntacx to disable /enable existing triggers on table are as below-

To Disable-

ALTER TABLE    [mySchemaName].[myTableName]  DISABLE TRIGGER myTriggerName

DISABLE TRIGGER  myTriggerName ON [mySchemaName].[myTableName]

To Enable-

ALTER TABLE    [mySchemaName].[myTableName]  ENABLE TRIGGER myTriggerName

ENABLE TRIGGER  myTriggerName ON [mySchemaName].[myTableName]

Custom Paging in SQL Server 2012Microsoft SQL Server 2012 has a customized clause for paging and it is efficient. Custom paging is t...How to execute long running SQL query or stored-procedure from .netSQL Server takes significant time to process (long running SQL statements) which leads to block the ...How to Speed-up Triggers in SQLTriggers are used to implement business rules, automate or to enforce referential integrity in datab...

CodePattern.net