Learn how to a build a cloud-first strategyRegister Now


profiler error message ...

Posted on 2014-08-13
Medium Priority
Last Modified: 2014-08-25
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?
Question by:25112
  • 2
LVL 23

Accepted Solution

nemws1 earned 2000 total points
ID: 40259143
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.

Author Comment

ID: 40263512
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?
LVL 23

Expert Comment

ID: 40263774
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.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question