i'm trying to get messages from sql server to appear in
english. at the moment you just get and ole error. the
server and the clients are set to british_english, but the
problem still exists. it seems to work if the client is
set to us_english. is this a bug within sql or just a
configuration problem.

thanks for any help

shaun

Shaun Buckley (shaun.buckley (AT) hsw (DOT) wales.nhs.uk) writes:
Since the setting of the client does not affect SQL Server at all,
I doubt that SQL Server is at fault at all.

You can use SET LANGUAGE to change the user's language at SQL Server
level, and this can give you a different language for the error messages.
But I believe the us_english messages are always used as a fallback.

You don't mention what software you have running on the clients, but
I think you need to investiate how your application show the messages.
It seems to be there the problem lies.

--
Erland Sommarskog, SQL Server MVP, sommar (AT) algonet (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Are you using placeholders in your English messages? Did you add them as us before adding them
as British?

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=d...blic.sqlserver


"Shaun Buckley" <shaun.buckley (AT) hsw (DOT) wales.nhs.uk> wrote