Excellent article.

I was having a permission denied on db_mail when sending a email from a sp that was being executed by Service Broker, and this was despite the user who...

Thanks Paul,

but I went with this instead, avoid anything that relies on DATEFIRST or regional

settings, and instead, define the week start explicitly in the query.

Here is one solution (using...

Hi AJ

just looked set DateFirst sets :

Permissions

SET DATEFIRST permissions default to all users.

So I don't really want to go there, any other ideas ?

Thanks again

Frank

Hi AJ

using select @@DATEFIRST brings me back 7 - for Sunday and

SELECT DATEPART(WEEKDAY, '2005-11-06')  brings back a 1,

quick question if I use SET DATEFIRST 1 will that not change the...