SQL XML SPID Settings

I found some nifty uses of xQuery and xPath expressions in SQL recently, but I also ran into some errors promoting to a server with some SPID settings. Turns out there's a page on MSDN with the exact settings that need to be set in order for things like xml.query() and xml.nodes() to work.

ANSI_NULLS ON
ANSI_PADDING ON
ANSI_WARNINGS ON
ARITHABORT ON
CONCAT_NULL_YIELDS_NULL ON
NUMERIC_ROUNDABORT OFF
QUOTED_IDENTIFIER ON

http://msdn.microsoft.com/en-us/library/ms188285%28SQL.105%29.aspx