The key...

Confusion

I learned something new today as well. Thanks.

Jeff Moden (6/17/2015)

---

mark.dickinson (6/17/2015)

---

B... Is there a way, based on the PostTime column, or a different column which could be added, to record only the most recent logon? For example,...

Michael L John (6/17/2015)

---

Sorry, I saw this post and ran out the door after I published the code.

1. I have a DBAUtilities database on all my servers. This...

Jeff Moden (6/17/2015)

---

eccentricDBA (6/17/2015)

---

Ed Wagner (6/17/2015)

---

Eirikur Eiriksson (6/17/2015)

---

Allium...

mark.dickinson (6/17/2015)

---

Michael L John (6/17/2015)

---

CREATE TRIGGER [Server_Logon_Trigger]

ON ALL SERVER

FOR LOGON

AS

INSERT INTO DBAUtilities.dbo.Server_Logon_History(EventType, PostTime, ServerName, LoginName, LoginType, SID, ClientHost, IsPooled)

SELECT EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)'),

EVENTDATA().value('(/EVENT_INSTANCE/PostTime)[1]', 'datetime'),

EVENTDATA().value('(/EVENT_INSTANCE/ServerName)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/LoginName)[1]',...

Garlic (Had to look that...

sqlstar2011 (6/17/2015)

---

I created a view in db1 database that points to tables in db2 database.

However when I try to run a select against the view in db1 database I get...

Michael L John (6/17/2015)

---

CREATE TRIGGER [Server_Logon_Trigger]

ON ALL SERVER

FOR LOGON

AS

INSERT INTO DBAUtilities.dbo.Server_Logon_History(EventType, PostTime, ServerName, LoginName, LoginType, SID, ClientHost, IsPooled)

SELECT EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)'),

EVENTDATA().value('(/EVENT_INSTANCE/PostTime)[1]', 'datetime'),

EVENTDATA().value('(/EVENT_INSTANCE/ServerName)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/LoginName)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/LoginType)[1]',...

Omlet

Hunting

Sabre

Dark

Thanks, but I can't claim credit for coming up with it. I first saw it years...