SQL and IUSR

[mattm31]

Hi

Not sure if i'm posting this in the right section but here
we go.

My server 2K server running SQL 2K and our Intranet was dying
so i cloned the disk and moved it to a new machine.

It came up fine and the Intranet which gets its stats from the SQL worked fine apart from its showing dates as m/d/yyyy
instead of dd/MM/yyyy as it was on the old machine.

I've checked all the regional setting but nothing seems to have changed from the old system.

Any suggestions anyone its driving me mad !!

Thanks

Matt

 

[gmmastros]

The problem is with the default language set for your logins. Read this, and you'll understand more about the problem, and how to fix it.

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom