Hello,
i'm using SQL Server 2005 Ex SP1, i would like to ask may be newbie question. On some machine have to input query in this datetime format '21.6.2006' and on the other one in '2006-06-21'. Collation setting is on both the same. What's dependin on, please?
Thank you for any help.
The formats in the user interface are usually depending on the regional settings for the user working with the application. You can check the current regional settings in control panel.
It is called Regional and language options.
|||I'm sorry Andreas,it's not. My regional setting is different. Have you any idea, please?
Thank you.
|||HI See with which user you are connecting to the database, there is a regional language setting per user which is defnied at SQL Server level.-Jens Suessmeyer.|||Thank you Jens for your reply. I'm using Windows Authentication mode, so Windows Domain user got some regional setting? Do i understand well, please? Thank you.|||Look under the default language for the appropiate user in the user properties.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||YES! That's it. Thank you Jens, for your kind and fully qualified help.
No comments:
Post a Comment