Query Analyzer vs Isqlw different Format

[Not4u]

Hello

I have a SQL 2000 server, the server setting is default language :
French and all Collation names in French
If i launch the 'Query Analyzer' from the SQL Entreprise Manager on my
database, and run a T-SQL my dates are in English.
If i do a : DBCC USEROPTIONS, my results are
language us_english
dateformat mdy

Now if i launch 'Query Analyzer' from the startup menu, my date format
is ok in French, if i do DBCC USEROPTIONS, results are:
language Français
dateformat dmy

In the Query Analyzer i checked the option in Tools>Options>Connections
(Use regional settings is unchecked) and they are the same in both case.

How can i resolve my problem ?
Thanks

[Erland Sommarskog]

Not4u (No***@chez.com) writes:

I have a SQL 2000 server, the server setting is default language :
French and all Collation names in French
If i launch the 'Query Analyzer' from the SQL Entreprise Manager on my
database, and run a T-SQL my dates are in English.
If i do a : DBCC USEROPTIONS, my results are
language us_english
dateformat mdy

Now if i launch 'Query Analyzer' from the startup menu, my date format
is ok in French, if i do DBCC USEROPTIONS, results are:
language Français
dateformat dmy

In the Query Analyzer i checked the option in Tools>Options>Connections
(Use regional settings is unchecked) and they are the same in both case.

It appears that you are login in with different logins from the two
tools. You can use sp_defaultlanguage to change the language for the
login which has the wrong language.

In Enterprise Manger, right-click the server and use Edit Registration
Properties to see which login to use for connection from EM.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp