trigger question!
-
Hi there,
I know this is silly question but confuse about it. I have to insert data in to table it has trigger on it. Do i need to disable it, if so How can i do that?
Thanks
-
What does the trigger do?
Can it cause conflit?
What's special about this task??
-
There must be a reason they put the trigger overthere !
If you're not sure, don't disable it !
If you're sure you are alowed to disable it, you can using this :
ALTER TABLE yourtable DISABLE TRIGGER all
First check there aren't triggers disabled yet, because you may not want to start them up later on !
after your operation, remember to enable them again !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Sorry forgot the most important....
Do that in a test environement (with backup).
-
Just as Alzdba said, there must be a reason why the trigger was placed on the table. You need to know what the trigger does before you go about disabling it. I am assuming it is an insert trigger?? I would find out what operations the trigger is performing and check with the powers-that-be to see if they want the results of the trigger to be reflected in whatever inserts you are doing.
If you do disable triggers.....test first!!
-
You need not drop the trigger to insert a record into a table. The insert will succeed if the trigger runs without an error
V.Kadal Amutham
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply