Good Article Divya....

This is Another way..

set datefirst 2

select datediff(dd,5,'12/17/2009')%7

set datefirst 5

select datediff(dd,5,'12/17/2009')%7