Menu
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.
557
To view database level triggers, Login to the server using SQL Server management studio and navigate to the database. Expand the database and navigate to Programmability -> Database Triggers. To view triggers at the server level, Login to Server using SSMS and navigate to Server Objects and then Triggers folder.
Server-scoped DDL triggers appear in the SQL Server Management Studio Object Explorer in the Triggers folder. This folder is located under the Server Objects folder. Database-scoped DDL triggers appear in the Database Triggers folder.
We can use the sys. triggers catalog view to check the existence of a Database scoped triggers. DML triggers are Database scoped triggers, where as DDL triggers can be DATABASE scoped or SERVER scoped.
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.
181
Here is where the Triggers for a specific table is located:
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
