Thursday, April 14, 2011

Get the SQL Server language settings using a single query? SQL Server

Easy to do:

SELECT
 s.name AS [Name],
 s.langid AS [LangID],
 s.dateformat AS [DateFormat],
 s.alias AS [Alias],
 s.days AS [Days],
 s.datefirst AS [FirstDayOfWeek],
 s.months AS [Months],
 s.shortmonths AS [ShortMonths],
 s.upgrade AS [Upgrade],
 s.lcid AS [LocaleID],
 s.msglangid AS [MsgLangID]
FROM
sys.syslanguages s

No comments:

Post a Comment