Any idea on how to default the date fields display to mm/dd/yyyy format in
SQL Server Management Studio 2008. This used to be working fine in SQL 2000
and SQL 2005.

rkbnair (rkbnair (AT) community (DOT) nospam) writes:
I know that Query Analyzer has a setting to respect regional settings,
but I cannot recall having seen any such setting for neither SSMS 2005
nor SSMS 2008.

If you want this behaviour, you can use QA also against SQL 2008. At work,
I still use QA, although of other reasons that the date format - I'm
perfectly happy with YYYY-MM-DD.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx