If you don't want to use a trigger any more, you should delete it from the database by using the "DROP TRIGGER" statement as shown in tutorial example:

USE GlobalGuideLineDatabase;

GO

DROP TRIGGER new_user;

GO

SELECT * FROM sys.triggers

GO

name  object_id parent_id type type_desc 

------------ ----------- ----------- ---- ------------

dml_message 690101499 674101442 TR SQL_TRIGGER 

Trigger, new_user, is deleted now.