SQL2000 - Find Database Language
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
select dateformat from master..syslanguages where langid = @@langid
Also see ...
SQL 2000 - Find version and service pack info
H3Run the following code in SQL Server 2000 Query Analyzer to return the Version and Service pack useful if you're having problems on a server and don't know if you're running the latest patches or not./H3Pdiv class="code" br /SELECT SERVERPROPERTY&40;'productversion'&41;, SERVERPROPE
H3Run the following code in SQL Server 2000 Query Analyzer to return the Version and Service pack useful if you're having problems on a server and don't know if you're running the latest patches or not./H3Pdiv class="code" br /SELECT SERVERPROPERTY&40;'productversion'&41;, SERVERPROPE