77

I created a simple trigger on Albums table. But that trigger is not visible in object explorer in programmability in triggers folder. I refreshed that folder as well as restarted the SSMS but still no luck. However i can see that trigger under that table in triggers folder. Is this a feature or a bug?

I am using SQL Server 2008.

halfer
  • 19,824
  • 17
  • 99
  • 186
TCM
  • 16,780
  • 43
  • 156
  • 254
  • possible duplicate of [Unable to find where triggers are stored in sql server 2008](http://stackoverflow.com/questions/3177594/unable-to-find-where-triggers-are-stored-in-sql-server-2008) – anar khalilov Dec 30 '13 at 08:38

4 Answers4

122

The triggers in Programmability is for database triggers (DDL Triggers). You can view the table triggers (DML Triggers) if you expand the table. For example, you are looking for triggers for table "students" Follow: expand "Tables"=> Expand "students"=> Here you will find DML triggers in Triggers Node.

KevDog
  • 5,763
  • 9
  • 42
  • 73
Mikael Eriksson
  • 136,425
  • 22
  • 210
  • 281
58

Here is where the Triggers for a specific table is located:

enter image description here

Israel Margulies
  • 8,656
  • 2
  • 30
  • 26
2

If you still can't find it, it is likely because you specified 

CREATE TRIGGER X
ON SERVER ALL

Specifying that it is deployed at the server level.

Expand server objects > Triggers

Asher
  • 348
  • 1
  • 3
  • 19
1

Collapse the tab of the Database and then refresh(F5) and expand TableName > Triggers> and here are your triggers(That need to be executed first before getting automatically saved.).

Ricardo F.
  • 496
  • 1
  • 4
  • 11