login info in sql error log

is there a reason why sql server does not put the corresponding login in error log.? they put spid, but a spid that is weeks old - is it useful to anyone?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
BrandonGalderisiConnect With a Mentor Commented:
Well you are reviewing logs that are weeks old :D.  Is it necessary to know the login for which an error occurred?  If you are trying to track down some sort of security breach, the error log will likely not help.
0
 
anushahannaAuthor Commented:
>>Is it necessary to know the login for which an error occurred?
at least that is more helpful than a SPID, not? :)

>>security breach, the error log will likely not help.
so what is the best bet to check something for security audit, when it was not pre-planned- what is the best we have in SServer?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
anushahannaAuthor Commented:
lcohan, helpful with parameters -thank you.
0
 
lcohanConnect With a Mentor Database AnalystCommented:
[
>>Is it necessary to know the login for which an error occurred?
at least that is more helpful than a SPID, not? :)
]
I would use SQL profiler and in there you select hostname, loginname, error, and any other columns you want then run it filtered where error > 0. SQL Logs have different purpose.

[
>>security breach, the error log will likely not help.
so what is the best bet to check something for security audit, when it was not pre-planned- what is the best we have in SServer?
]


your OS event viewer has detailed info about any "security breach"
0
 
anushahannaAuthor Commented:
very fine - thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.