Query to find LOGON triggers from any SQL Server Instance

Question

I have created Logon Triggers in SQL server instances.

How can I get the logon trigger name using t-sql(query) in SQL server.

Thank you in Advance.

Answer 1

You get it from DMV server_trigger

select *
from sys.server_triggers

Answer 2

Try this one

Use master
go
SELECT * -- [name]
FROM sysobjects
WHERE type = 'P'
  AND OBJECTPROPERTY(id, 'ExecIsStartUp') = 1;