Msg 15123 says the configuration option does not exist or may be an advanced option. Turn on show advanced options with sp_configure first, then set it.
geometry STEquals: Equal Shapes Can Have Different Text
geometry STEquals compares the represented point set, which can stay the same when its text representation changes. I separate that question from byte-for-byte text identity. Reversing a line does not necessarily change the places it occupies.
SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network
Find every SQL Server on network with one command: sqlcmd -L or osql -L lists the instances on your local network. An update to my old isql script.
SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache
A guest post from Michael Coles, author of Pro SQL Server 2008 XML: a practical XML demo that looks at the query plan cache and the cost of cached operations.





