Change language on SQL Server 2005 permanently

Question

Hi, I'm looking how to change the language from English to Spanish permanently, for all sessions.

I reached it with this statement:

SET LANGUAGE spanish

But when I start a new session the English language comes back.

Thanks.

Answer 1

Problem solved! I have changed the Default Language from English to Spanish modifying the properties of my login user.