SQL2000 - Find Database Language

Contributed by katy8439 May 8, 2007  
Tagged: Database

How to find the system language of a server running SQL2000 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