December 24, 2007 at 12:37 am
Hi Everybody,
I have Five trigger asoociated with table called employee.
From where i find the order of trigger associated with employee table
so i can change the order according to me.
December 24, 2007 at 1:00 am
- There shouldn't be an order-dependency in the triggers !!
- sp_settriggerorder allows you to set the First and Last trigger.
(check BOL)
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
December 24, 2007 at 6:41 am
thanks for your response....
but I know how to set trigger order i want information about the object who contain the order of execution of trigger on a table ..
December 24, 2007 at 8:25 am
I wouldn't advise to tamper with it, but you might want to script proc [sys].[sp_settriggerorder]
SELECT *
FROM sys.triggers
WHERE parent_ID = OBJECT_ID('HumanResources.Employee')
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
December 24, 2007 at 8:51 pm
No Dear iam not anger but table('sys.trigger') you specified is not exists
on any databases so how i can get the infornation when the table you specified in the code is not exists. can you try this code some where else and iam working on sql 2000.
plz send me the tested code as i can run it frequntily.
December 24, 2007 at 11:56 pm
I guess you have posted the question in the wrong forum. You should have posted it in SQL Server 2000 forums.
SQL server 2000 does not have the view sys.triggers. Read dinesh Asanka's article http://www.sqlservercentral.com/articles/SQL+Puzzles/triggerstoexecuteinpredefinedorder/2337/
towards the end of the article he has shown an example which shows how to retrieve the order of the triggers.
.
December 25, 2007 at 8:17 am
varun-jha (12/24/2007)
No Dear iam not anger but table('sys.trigger') you specified is not existson any databases so how i can get the infornation when the table you specified in the code is not exists. can you try this code some where else and iam working on sql 2000.
plz send me the tested code as i can run it frequntily.
as jacob sebastian already replied, that code is for sql2005 because the forum you posted in was SQL2005.
Read the article he mentioned to go on with your quest.
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
December 25, 2007 at 10:32 am
Thank for every one i get the concept after reading the article....
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply