I'm using SQL Server CE for rapid application development purposes and have hit a little snag - it doesn't seem to support changing the start day of the week.
What I've tried:
SET DATEFIRST 1;
which yields: Unrecognized SET statement
as a response (both via a query window and through code). I've googled around and can't find anything in the documentation as to whether changing the start date of a week is supported or isn't supported by SQL Server Ce, nor can I find any alternative method of changing this.
Am I doing something stupid, or can anyone confirm that this isn't supported (or perhaps both?)
It is not supported - why not just fix in C# code?