Cme funziona il trigger e dove lo trovo?

USE pubs;

EXEC sp_helptrigger @tabname = N'employee';

/* Output:

trigger_name     trigger_owner  isupdate    isdelete    isinsert    isafter     isinsteadof
---------------- -------------- ----------- ----------- ----------- ----------- -----------
employee_insupd  dbo            1           0           1           1           0

(1 row(s) affected)

*/

/* Visualizzo il suo codice */
EXEC sp_helptext @objname = N'employee_insupd';

/* Output:

Text
----------------------------------------------------------------

CREATE TRIGGER employee_insupd
ON employee
FOR insert, UPDATE
AS
--Get the range of level for this job type from the jobs table.
declare @min_lvl tinyint,
   @max_lvl tinyint,
   @emp_lvl tinyint,
   @job_id smallint
select @min_lvl = min_lvl,
   @max_lvl = max_lvl,
   @emp_lvl = i.job_lvl,
   @job_id = i.job_id
from employee e, jobs j, inserted i
where e.emp_id = i.emp_id AND i.job_id = j.job_id
IF (@job_id = 1) and (@emp_lvl <> 10)
begin
   raiserror ('Job id 1 expects the default level of 10.',16,1)
   ROLLBACK TRANSACTION
end
ELSE
IF NOT (@emp_lvl BETWEEN @min_lvl AND @max_lvl)
begin
   raiserror ('The level for job_id:%d should be between %d and %d.',
      16, 1, @job_id, @min_lvl, @max_lvl)
   ROLLBACK TRANSACTION
end

*/

USE master;

BACKUP DATABASE AdventureWorks
TO DISK = 'C:\AdventureWorks.bak';

/* Output:

Processed 21168 pages for database 'AdventureWorks', file 'AdventureWorks_Data' on file 1.
Processed 2 pages for database 'AdventureWorks', file 'AdventureWorks_Log' on file 1.
BACKUP DATABASE successfully processed 21170 pages in 22.196 seconds (7.813 MB/sec).

*/

RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\AdventureWorks.bak'
WITH
MOVE 'AdventureWorks_Data' TO 'C:\AdventureWorks_Data.mdf',
MOVE 'AdventureWorks_Log' TO 'C:\AdventureWorks_Log.ldf';

/* Output:

Processed 21168 pages for database 'AdventureWorks', file 'AdventureWorks_Data' on file 1.
Processed 2 pages for database 'AdventureWorks', file 'AdventureWorks_Log' on file 1.
RESTORE DATABASE successfully processed 21170 pages in 42.553 seconds (4.075 MB/sec).

*/