C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Abhi (38)
divya (34)
Babu Akkandi (28)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Temporarily disable a trigger?

Posted Date: 27 May 2008	Resource Type: Code Snippets	Category: SQL
Author: Binu Kumar	Member Level: Silver
Rating:	Points: 10

Temporarily disable a trigger?

People wants to disable a trigger for a short period of time while they did work on the system that was not typical for their application. Rather than delete the trigger and re-create it later, here is some code that you can run in one statement (and inside a transaction, if required):

ALTER TABLE tablename DISABLE TRIGGER ALL
-- do work here
ALTER TABLE tablename ENABLE TRIGGER ALL

Responses

Author: RajaSekaran R 03 Jun 2008

Member Level: Gold Points : 0

Good One..

Author: Kapil Dhawan 17 Jun 2008

Member Level: Gold Points : 2

Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil

Feedbacks

Popular Tags

What are tags ?

Search Tags

Syntax for disabling/enabling a trigger .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to Date Format In Database
	Previous Resource: Export/Import Data from Database to Excel sheet
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design