SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error logging SQL 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JacobOstop
Starting Member

2 Posts

Posted - 11/19/2012 :  14:56:56  Show Profile  Reply with Quote
I am searching through my error logs and i was thinking it would show someone who got disconnected from the server. But when i look through my logs all i mostly see are informational logs saying a backup was done or a transaction log was backed up. I was wondering is there somewhere i have to adjust what is actually being logged? If so how am i able to do this.

Thanks!

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 11/19/2012 :  15:24:11  Show Profile  Visit tkizer's Homepage  Reply with Quote
You could run a trace to log this, but I don't think I'd recommend it.

Why do you want to see this?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 11/19/2012 :  15:24:11  Show Profile  Reply with Quote
If you are looking to Audit for Failed or Success logins, You can do it Right Click Server Properties under Security tab,You can audit them.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 11/19/2012 :  15:24:37  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by sodeep

If you are looking to Audit for Failed or Success logins, You can do it Right Click Server Properties under Security tab,You can audit them.



That doesn't show disconnects.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000