MS SQL Server Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
Can You Create a Logon Trigger in SQL Server 2005 Express Edition?
Answer:
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 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.
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.
Download MS SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can You Roll Back the DDL Statement in a Trigger? | What Are Cursors in MS SQL Server? |