Billy
Do not open SSMS , instead of run SELECT statement in query builder and use
CONVERT system function that has a third parameter named style
See details in the BOL
"Billy" wrote in message
> Hello!
>
> Can anybody tell me where I can set in SQL Server Management Studio
> 2008 that I will see date columns formatted in style "dd.mm.yyyy" like
> it is in SSMS 2005 or in SQL 2000?
>
> With that I mean if I open any table in any db with datetime columns
> inside with command "Edit Top 200 rows" or "Select Top 1000 Rows" I
> see date in form e.g "2009-10-25 14:40:00.000" instead of "25.10.2009
> 14:40.000". If I open same table in SSMS 2005 I see in "dd.mm.yyyy"
> format.
>
> Regards,
> Biilly >> Stay informed about: Why is displayed date format different in SSMS 2008?