An error has occurred while establishing a connection to the server, also known as Error 40, is the top error searched on my blog. Here is the fix in screenshots.
SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)
Msg 9514 means a distributed query touched an XML column. Why the type cannot cross a linked server, and four ways to get the data across anyway.
SQL SERVER – Spatial Database Definition and Research Documents
What is a spatial database? It is about lines, points, polygons and their features, and SQL Server was not one. My simple answer plus research documents.
SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
A script and UDF that show each current week date with its day, from Sunday to Saturday, using DATEPART and DATEADD. Handy for a weekly calendar report.
SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
Insert multiple records with one INSERT statement by combining SELECT and UNION ALL, instead of a separate INSERT for every row. SQL Server 2008 has a newer way.
How to Read a T-SQL Syntax Diagram
Read a T-SQL syntax diagram without guessing: brackets mean optional, braces mean required choices, pipes separate options, and dots repeat items.
How to Read a SQL Server Build Number
Learn how a SQL Server build number identifies the engine release, maps to a cumulative update, and explains differences between two instances.