SQL Server 2000 – Find Database Language

Posted May 8, 2007 by katy8439 in Database

How to find the system language of a server running SQL Server 2000 using a SQL statement.

I recently had a client who was having problem with date format in SQL2000 after moving from a UK based server to a German one. In order to check that the database was set to the correct language locale, run the following code in Query Analyser and the database language will be returned:

select @@langid, @@language

select dateformat from master..syslanguages where langid = @@langid

The Conversation

Follow the reactions below and share your own thoughts.