Unable to find where triggers are stored in sql server 2008

sql-server triggers

You can find Triggers under Table node:

enter image description here

sql-server triggers

Under the Tables node in SSMS (SQL Server Management Studio), for each table there is a Triggers node.

You can manage your triggers from there.

sql-server triggers

Here is a better way:

select a.[name] as trgname, b.[name] as [tbname] from sys.triggers a join sys.tables b on a.parent_id = b.object_id

Just be sure to run it against the database where you think the trigger is located.

CodeHunter