Identifying problematic triggers
You've identified an issue when placing new orders in the company's sales system.
The issue is related to a trigger run, but you don't have many details on the triggers themselves. Unfortunately, the database objects (including triggers) are not documented.
You need to identify the trigger that's causing the problem to proceed with the investigation. To be sure, you need to gather some important details about the triggers.
The only information you have when starting the investigation is that the table related to the issues is Orders.
Bu egzersiz
Building and Optimizing Triggers in SQL Server
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Get the table ID
SELECT ___ AS TableID
FROM sys.objects
WHERE ___ = '___';