CODEWITHSUNDEEP
sql-server-2008
Patrick J Collins
Patrick J Collins

Reputation: 1009

Change language of error messages in SQL Server Management Studio

I'm using SQL Server Management Studio 2008 to write a bunch of queries. I have installed French versions of Windows XP and SQL Server thus all SQL error messages appear in French. I would prefer to see the error messages in English. Any idea how to change the language of the error messages? I won't reinstall the machine.

Patrick

Upvotes: 13

Views: 10129

Answers (3)

Maksim
Maksim

Reputation: 41

I had the same problem, in the SSMS international settings was English, but the error messages after queries were in the same language as the environment language.

SET LANGUAGE ENGLISH command didn't work for me. I have SSMS 2018 version. After some research, I found the solution.

In the initial connection to the server in the "Connect to Server" tab, choose Options -> Additional Connection Parameters.

In there input this:

Language=English

And connect to the server, query error messages started to be in the English language.

Upvotes: 2

ercan
ercan

Reputation: 1716

You must pay attention to case, depending your server configuration. In "case sensitive" servers:

SET LANGUAGE English

Upvotes: 6

Patrick J Collins
Patrick J Collins

Reputation: 1009

I found the solution 1 minute later :

SET LANGUAGE ENGLISH

Upvotes: 19

Related Questions