SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Create a synonym on table with xml column
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mitza
Starting Member

2 Posts

Posted - 09/24/2013 :  00:23:27  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3706 Posts

Posted - 09/24/2013 :  08:30:26  Show Profile  Reply with Quote
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

Edited by - James K on 09/24/2013 08:30:46
Go to Top of Page

mitza
Starting Member

2 Posts

Posted - 09/24/2013 :  08:37:55  Show Profile  Reply with Quote
Thank you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000