About international setting of MSSQL 2000

Our company is moving from SQL Server 7 to SQL Server 2000.
In SQL Server 7 it was possible to add an alternate
language (via sp_addlanguage) but this functionality is
discontinued in SQL Server 2000.
Is there a way to add an alternate language in SQL Server
2000?

Checked that the below website does not work.
http://msdn.microsoft.com/library/de...asp?frame=true

From Books Online:
The default language for a login can be overridden by using sp_addlogin or
sp_defaultlanguage. The default language for a session is the language for
that session's login, unless overridden on a per-session basis using the ODBC
or OLEDB APIs.

So you can also set the language in the ODBC and OLEDB settings.

Hope this helps!

-- Ipconfig

"DaveHenson" wrote:

> Our company is moving from SQL Server 7 to SQL Server 2000.
> In SQL Server 7 it was possible to add an alternate
> language (via sp_addlanguage) but this functionality is
> discontinued in SQL Server 2000.
> Is there a way to add an alternate language in SQL Server
> 2000?
>
> Checked that the below website does not work.
> http://msdn.microsoft.com/library/de...asp?frame=true
>