March 21, 2008 at 1:15 pm
Hi Guys
is there any way to see who logged on sql server in perticular interval like
suppose some one connected sql server via query analyzer between 9 -9.30
i need to check that later in the day or another day.Other than Event Viewer
March 21, 2008 at 2:00 pm
It is possible if you have "Both failed and successful logins" enabled.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 21, 2008 at 2:07 pm
SQL can track successful and unsuccessful logins by default ... you have to enable the option, which requires a SQL restart:
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, 3
GO
This can be viewed by right clicking your database server, properties, security.
March 21, 2008 at 5:52 pm
setting "Both failed and successful logins" thru Management Studio will do same as changing registry directly.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply