[SOLVED] mssql set language

[eluser]fdog[/eluser]
I need to change the language of my app using mssql.

For example:

Code:

Set language Spanish;
select datename(MM,getdate());

That will output "Septiembre".

The problem is that CodeIgniter doesn't seem to get the 'Set language Spanish' part.
I tried using

Code:

$this->db->simple_query('Set language Spanish')

before doing my regular queries, but it didn't work.
Does anyone knows how to get that working?

Thank you.

[eluser]fdog[/eluser]
Never mind. It was my mistake. I just forgot to convert the date from the database.