SQL2000 – Find Database Language

Contributor Icon Contributed by katy8439 Date Icon May 8, 2007  
Tag Icon 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

Previous recipe | Next recipe |
 
blog comments powered by Disqus