Tuesday, August 12, 2008

How to find current dateformat configured on SQL Server 2005

SELECT name ,alias, dateformat
FROM master..syslanguages
WHERE langid =( SELECT value
FROM master..sysconfigures
WHERE comment = 'default language')

No comments: