Have you checked the environment settings in the Control Panel.  Perhaps
this machine is set up to display dates differently.  I know many
applications rely on the setting in the Control Panel - so maybe Enterprise
manager is the same.  I've seen this particularly with the Y2K hoopla -
where some machines would have a date format of mm/dd/yy and others have
mm/dd/yyyy so dates would either be displayed as 2 or 4 digits depending on
this setting.

Hope this helps.

----- Original Message -----
From: "Nick Middleweek" <nickm@t...>
To: "sql language" <sql_language@p...>
Sent: Tuesday, October 10, 2000 7:43 AM
Subject: [sql_language] Date formats?


> Please Help!
>
> I've moved a SQL Server db from one machine to another. The installation
was
> done by someone else over the weekend.
>
> We've taken backups from the existing server and restored them onto this
new
> box but when I view date fields in the Enterprise manager the day and
months
> have switch. This is causing problems with my ASP files and I'm getting
> funny results. <http://www.trendmachinery.co.uk/shows.asp>. You can see
that
> the date list is not in the correct month section.
>
> Are there settings for the SQL Server date format on installation?
> I've compared the OS dates and time zone and they're the same.
>
> I don't know where else to look? I initially thought this was a data
problem
> or a DTS corruption until I compared the date values and thought how can I
> have a month of the value 17?
>
>
> Thanks in advance!
>
> Regards
> Nick Middleweek
>