How can I disable the windows authentication mode of SQl Server
- by Azhar
How can I disable the windows authentication mode of SQl Server and restrict it to ask for user and Password every time and no windows authentication. for security purposes
I need to keep track of the last login time for each user in our SQL Server 2005 database.
I created a trigger like this:
CREATE TRIGGER LogonTimeStamp
ON ALL SERVER FOR LOGON
AS
BEGIN
IF EXISTS (SELECT * FROM miscdb..user_last_login WHERE user_id = SYSTEM_USER)
UPDATE miscdb..user_last_login SET last_login = GETDATE() WHERE user_id =…
