Create a synonym on table with xml column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Create a synonym on table with xml column

Author

Topic

mitza
Starting Member

2 Posts

Posted - 2013-09-24 : 00:23:27

Hello world.
I have the following problem.
With two servers (Server 1 and Server 2). On Server 1 create a synonym for a table that is on Server 2 which contains a column of type XML. The synonym is created, but can not be accessed, resulting in the following error (select * from Synonym_name / select convert (nvarchar (max), XML_column) from Synonym_name)
"Msg 9514, Level 16, State 1, Line 1
XML Data Type is not supported in distributed queries. Remote object 'Synonym_name' has xml column (s). ".
Thank you.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-24 : 08:30:26

I don't think it is the synonym that is the problem. It is the XML column - this is a limitation of SQL Server - see this connect issue: http://connect.microsoft.com/SQLServer/feedback/details/338953/msft-maddog-cant-do-a-distributed-query-into-a-table-w-xml-columsn-even-if-youre-not-referencing-the-xml-column

Editing: Saw couple of workarounds here: http://stackoverflow.com/questions/14442039/why-do-i-get-the-error-xml-data-type-is-not-supported-in-distributed-queries-w

mitza
Starting Member

2 Posts

Posted - 2013-09-24 : 08:37:55

Thank you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources