Can You Create a Logon Trigger in SQL Server 2005 Express Edition?
Submitted by: AdministratorCan 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 GlobalGuideLineDatabase 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.
Submitted by: Administrator
CREATE TRIGGER welcome ON ALL SERVER
AFTER LOGON
AS
PRINT 'Welcome to GlobalGuideLineDatabase 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.
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | Does Index Slows Down INSERT Statements? |
☺ | What Are the Character String Functions Supported by SQL Server 2005? |
☺ | How to create new table with "CREATE TABLE" statements? |
☺ | What Happens If Date-Only Values Are Provided as Date and Time Literals? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |