Hi,
We have a server (SQL 2005) set up as US date format
and have tried to change it to UK using syslanguage etc
Anyone know how to do it at a global level so we dont have to change lots of SP
Regards
Stu
Datetimes are stored language independent in SQL Server. Its the setting of the user which makes the datetime appear in the local format. if you Change the individual setting of the user, the datetime will be displayed in the appropiate format. If you want to set the default language for any new logins you can use the sp_configure with the default language option.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment