Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User LOGIN Info

Status
Not open for further replies.
Hpatel

Hpatel

IS-IT--Management
Joined
Apr 3, 2001
Messages
21
Location
US
I need to get information on All the user Logged in the SQL Server and what time they gotin in specific Time period.
EX: Login info fot All the user from 8 AM to 1 PM that login to SQL SERVER. Need this ASAP. ANY help would be appreciated.
THX,
 
Sort by date Sort by votes

SQL Server doesn't track user logins. Unless you've created or installed a tracking process, you can't get that info. You could make sure all login attempts are logged in the SQL Error log. However, it is difficult to extract the data and the log could become huge. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Marclem
  • Locked
  • Question Question
Get Opinio Last Login Data
Replies
5
Views
610
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question Question
Last date per userid
Replies
3
Views
485
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question Question
Determine sa Password When Signed On As Administrator User Thru Windows Authentication
Replies
2
Views
332
Auguy
Auguy
baran121
  • Locked
  • Question Question
sql user default language problem
Replies
7
Views
507
gmmastros
gmmastros
EM1107
  • Locked
  • Question Question
Help finding a way to show my information on one row
Replies
11
Views
496
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top