August 10, 2011 at 2:58 pm
While going thru the log files today I came across what I would consider an odd entry; 2 to be exact. The first line (in order of first execution tolast execution) reads:
Date2011-08-09 10:01:25 PM
LogSQL Server (Archive #1 - 2011-08-10 2:00:00 AM)
Sourcespid71
Message
SQL Trace ID 2 was started by login "bubba".
where bubba is used as a generic place holder. The next line after it reads:
Date2011-08-09 10:01:45 PM
LogSQL Server (Archive #1 - 2011-08-10 2:00:00 AM)
Sourcespid73
Message
SQL Trace stopped. Trace ID = '2'. Login Name = 'bubba'.
SOME FACTS:
1) There was no job that ran at that time
2) The bubba login is a SQL Login that no one should be using save for me and I was not at work or woriking nor even connected to the SQL Server when this occurred.
Thoughts? One other odd item to point out is the use of double quotes qround teh login name in the first entry and the sue of single quotes around the login name in the second entry. That difference is in the log and not just a grammar error by me when re-posting the code here.
Kindest Regards,
Just say No to Facebook!August 10, 2011 at 3:05 pm
I have sql monitor installed here and the logs is full of messages like this one.
Someone / something started a trace, you can be sure of that.
August 10, 2011 at 3:07 pm
I've seen this with Quest Spotlight as well.
August 10, 2011 at 3:17 pm
I'm guessing that there is some type of third party tool that kicked off a trace.
August 10, 2011 at 3:33 pm
Steve Jones - SSC Editor (8/10/2011)
I'm guessing that there is some type of third party tool that kicked off a trace.
Well I do have SQL Monitor running and it is monitoring the DB Server containing the log with these entries however its configured to use a SQL Login that differs from what is in the log file and I just double checked that before postying this reply so I could be certain this was still the case.
Whats odd to me is how the trace itself is so short in duration.
Kindest Regards,
Just say No to Facebook!August 10, 2011 at 3:41 pm
Matches SM MO. It starts shorts traces to log something then shut it right down...
August 10, 2011 at 3:46 pm
Ninja's_RGR'us (8/10/2011)
Matches SM MO. It starts shorts traces to log something then shut it right down...
Whats SM MO?
Kindest Regards,
Just say No to Facebook!August 10, 2011 at 3:53 pm
SM = SQL Monitor
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply