Creating a Logon Trigger in Express Edition in SQL Server

Q

Can You Create a Logon Trigger in SQL Server 2005 Express Edition in SQL Server?

✍: FYIcenter.com

A

Can you create a logon trigger in SQL Server 2005 Express Edition? The answer is no. LOGON is not a supported event type in Express Edition. The script below shows you the error message when you try to create a logon trigger:

CREATE TRIGGER welcome ON ALL SERVER
AFTER LOGON
AS
  PRINT 'Welcome to FyiCenterData database!';
GO
Msg 1084, Level 15, State 1, Procedure welcome, Line 2
'LOGON' is an invalid event type.

Or may be there is a configuration setting that disables the logon event type.

 

Creating and Managing Triggers in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-22, 592👍, 0💬