Hi i need to install a Msde on italian server.

i set rigth the collation - caracter set and sort order but i found that
language for the sqlserver is set "italian"
how can i change it to english?

I look on setup.ini settings without success.....

i found another db that has set englis languge and was installed on italian
xp

thank you

dan

hi Dan,
[quoted text, click to view]

the localized versions of MSDE will always default each created login to the
localized language, but you can specify a different default language via the
system stored procedure sp_configure,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_0put.asp,
specifying a different value for it
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_3xny.asp..

as already said, language is login specific and you can set it as
desired/required in the @language parameter of the sp_addlogin sytem stored
procedure
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_0q7i.asp ,
and you can modify existing logins values via the system stored procedure
sp_defaultlanguage
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_2tk5.asp
as desired for each login...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply