Change language of error messages in SQL Server Management Studio

Question

Hi all,

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

Answer 1

I found the solution 1 minute later :

SET LANGUAGE ENGLISH

Answer 2

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

SET LANGUAGE English