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, 2304🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...