September 2, 2009 at 2:08 pm
I am currently working with a SQL2005 database that was specified to use triggers to log changes to certain key tables so that changes to k_fred were logged to l_fred
Rather than trawl through a script dump of the entire database, can I use the system view SELECT * FROm sys.triggers with a join on object_id to identify the table and determine the prescence (or absence) of triggers?
September 2, 2009 at 2:09 pm
Yep. Assuming you mean join the parent_id in sys.triggers to the object_id in sys.all_objects.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 2, 2009 at 2:14 pm
Thank you.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy