在数据库中存储登录和注销历史记录(sqlserver 2005) [英] Storing Login and Logout History in DATABASE (sqlserver 2005)

问题描述

嗨FrNdS !!

如何在数据库中创建和存储用户登录的登录和注销历史记录详细信息.

Hi FrNdS !!

How to create and Store Login and LogOut History details of User Logins into DATABASE.

推荐答案

您将编写代码以使用DAL类进行处理.如果遇到特定问题，请告知我们.

You will write code to handle it using your DAL classes. Please let us know if you run into a specific problem.

目前，我只能通过SQL Server触发器存储登录信息

/*
创建表Login_Info
(
Login_Name NVARCHAR(256)，
Login_Time DATETIME，
Host_Name NVARCHAR(128)
)
*/

创建触发器Conn_Limit
在带有AS的所有服务器上执行'sa'
用于登录
AS
开始
INSERT INTO master..Login_Info
SELECT ORIGINAL_LOGIN()，GETDATE()，
EVENTDATA().value(''((/EVENT_INSTANCE/ClientHost)[1]''，''NVARCHAR(128)'')
END

Presently I am only able to store Login Information by SQL Server trigger

/*
CREATE TABLE Login_Info
(
Login_Name NVARCHAR(256),
Login_Time DATETIME,
Host_Name NVARCHAR(128)
)
*/

CREATE TRIGGER Conn_Limit
ON ALL SERVER WITH EXECUTE AS ''sa''
FOR LOGON
AS
BEGIN
INSERT INTO master..Login_Info
SELECT ORIGINAL_LOGIN(), GETDATE(),
EVENTDATA().value(''(/EVENT_INSTANCE/ClientHost)[1]'',''NVARCHAR(128)'')
END

只需在登录和注销应用程序时在表中插入当前时间(getdate()).

Just Insert current time (getdate()) in your table while logging in and logging out in your application.

这篇关于在数据库中存储登录和注销历史记录(sqlserver 2005)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！