Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
runnerpaul
Starting Member
24 Posts |
 Posted - 2012-03-19 : 06:56:40
|
| Hi,I want to find out who was logged into a database(username/hostname) on Friday 19th March between 15:00 and 16:00. How do I go about this?ThanksPaul |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-19 : 08:38:58
|
| Did you have a server-side audit running catching the audit:login and audit:logout events? Are you logging successful logins to the error log? Got a login trigger recording login events? Got SQLAudit enabled--Gail ShawSQL Server MVP |
 |
|
|
alishaali
Starting Member
8 Posts |
Posted - 2012-03-28 : 04:12:46
|
| Hi,you can see this way too..[Start]--[Administrative tools]--[event viewer]..this will be much clear for filter |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-28 : 07:37:15
|
quote:
Originally posted by alishaali
Hi,you can see this way too..[Start]--[Administrative tools]--[event viewer]..this will be much clear for filter
Not if successful logins weren't being recorded, which is not the default and not usually a good idea.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Who was logged into database?