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, 1736🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...