My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Locale in indexed views Design v Runtime
The new RSS feed is here
Following on from a post I made on Precise and deterministic dates in an indexed view. Jeff Lowery and I have been having a discussion on what and why, and I think we have come to the conclusion that it would be nice to be able to have the view use the locale as it was at compile time. This is just like using the security context that is used at design time which is available in SQL 2005.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Locale in indexed views Design v Runtime