It is hard to live without tool like Xenu's Link Sleuth in today Internet age. This tool help me with projects at work. I scanned this blog and found that I need to do some cleaning here as well.
"Xenu's Link Sleuth (TM) checks Web sites for broken links. Link verification is done on "normal" links, images, frames, plug-ins, backgrounds, local image maps, style sheets, scripts and java applets. It displays a continously updated list of URLs which you can sort by different criteria. A report can be produced at any time. "
http://www.msdner.com/dev-archive/84/19-85-847101.shtmSELECT
Cast(a.XML_Data as XML) as XML_Data
FROM
OPENQUERY([LINKED SERVER NAME HERE],'
SELECT
Cast(XML_Data as Varchar) as XML_Data
FROM
[DATABASE NAME].[SCHEMA].[TABLE NAME]'
) A
Basically, the data is queried on the remote server, converts the XML data to a varchar, sends the data to the requesting server and then reconverts it back to XML.
StephenDudzic at 2007-9-3 22:09:22 >
"Re: XML data type not supported in Distributed Queries
This is a limitation in SQL Server 2005. Columns of xml type or CLR type cannot be queried directly or referenced from one server to another - this means the following:
- You cannot use a table or view that contains xml or clr type as 4-part name in your query
- You need to cast the column to either nvarchar(max) or varbinary(max) or other appropriate type to use
- If you have a table that has xml type for example then you need to create a view that contains all columns other than xml and query it instead. Or you can issue a pass-through query using OPENQUERY with the appropriate columns only."
