Collections:
Creating a Logon Trigger in Express Edition in SQL Server
Can You Create a Logon Trigger in SQL Server 2005 Express Edition in SQL Server?
✍: FYIcenter.com
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 Schemas in SQL Server
⇐ Rolling Back the DDL Statement in a Trigger in SQL Server
2016-10-22, 1810🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...