This one goes out to all non-americans
As we all know, dates should be represented on the format
dd.mm.yyyy - or derivatives thereof.
so here is the case: Sql Server 2000 will, in its
Enterprise Manager, display all dates on the format
as defined by the regional settings of the local user
looking at the database.
both the Database and the Sql Server has settings for locale and
language etc. but they are all overridden by the locale of the user.
keep this in mind when, oh say, remoting into a server using some
admin user to do stuff on the DB through E.M.
You might just be editing dates the "wrong" way