Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 European weeks in SQL Server CE

Author  Topic 

Starting Member

6 Posts

Posted - 2007-04-08 : 07:10:39
Hi, I have a problem with the region settings on SQL Server Compact Edition.
To begin with, in my C# Windows Mobile app, I start with fetching records for the current month from SQL Server 2005 Express.
That works without any problems, however, when I try to filter these records locally by weeknumber something happends;
SQL Server CE uses Sunday as the first day of the week, which is inconvenient since I live in Europe
I tried to "SET DATEFIRST 1" in a query prior to the one fetching weekly records but that just result in an exception.

Does anyone know how to change the regional settings on SQL Server CE?

- Advertisement -