profiler error message ...

Sometimes, in profiler, under the eventclass 'user error message', the textdata is

"Changed language setting to us_english."
"Changed database context to 'msdb'."

Why would be this a error message?
LVL 5
25112Asked:
Who is Participating?
 
nemws1Database AdministratorCommented:
Well, it is an error message - more specifically, a "user" error message.  You would normally call this a PRINT statement.  In other words, this is a RAISERROR() with a an error level of 0.  PRINT is actually doing something client-side, not server side.  In order for SQL to send it to the user and have it *not* appear as data being SELECT()ed, it is sent as a very-low-level error.
0
 
25112Author Commented:
thank you.. so these are 'helpful' message more than 'error message' in reality, right?

a)is it possible to tell sql to not count these as user error messages by any chance?
b)the login who is reporting this is the service account. but on the other server, I don't see any message like this for the service account. why may it be so?
0
 
nemws1Database AdministratorCommented:
It depends... any chance you can post specific examples from the 2 hosts?  You can filter them out in SQL Profiler for sure, but I don't think that's what you're asking.
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.