CODEWITHSUNDEEP
sqlsql-serversql-server-2008-r2
mehdi lotfi
mehdi lotfi

Reputation: 11571

change SQL Server error message to another language

How I can change SQL Server error message to another . I am using SQL Server 2008 R2 with Windows server 2008 r2 enterprise and want to change error message to persion language.

Upvotes: 0

Views: 1795

Answers (3)

ChrisM
ChrisM

Reputation: 1586

Persian isn't a language supported on SQL Server 2008 R2

To see the supported languages click here

You could also find them by using

 SELECT name, alias 
 FROM sys.syslanguages

If you then want to change the language to Italian for example use

SET LANGUAGE Italian

Further info on SET LANGUAGE here

Upvotes: 0

Remus Rusanu
Remus Rusanu

Reputation: 294297

SET LANGUAGE:

Specifies the language environment for the session. The session language determines the datetime formats and system messages.

I don't think there is a Persian edition though, see the list at sys.syslanguages

Upvotes: 2

juergen d
juergen d

Reputation: 204766

try setting the language like this

SET LANGUAGE ENGLISH

Upvotes: 1

Related Questions