MS SQL Server, finding user defined Triggers


I have an application that I support which is already developed by a company.  It uses MS SQL Server 2005, and all the tables and triggers have been defined by the company.  Our company went ahead and added our own defined triggers.  Is there a way I can figure out using a query which triggers we have created and which ones came with the software.  There are like thousands of triggers.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
no, unless either of the companies had some "comment" in the triggers that identified the trigger being created by whom ...apart from that, you might find some date creation time in sys.objects that might help ...
If you know when your company bought the application you could check creation and/or modification date

USE [YourDB]
FROM sys.triggers
WHERE create_date > 'fill in your date'
OR modify_date AS ModifyDate > 'fill in your date'

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
leave out 'AS ModifyDate', I copy-pasted to fast :)
Bhavesh ShahLead AnalystCommented:
Check out this.

it helps you to get trigger with table name
select 'Table', 'Trigger', b.RefDate
from sysobjects a inner join sysobjects b
on = b.parent_OBJ
AND B.Type ='TR'

Open in new window

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.