Archive for September, 2012

Query table containing spatial datatype over linked server

By admin - Last updated: Saturday, September 22, 2012

If the target table containing column with spatial datatype, and you like to do the following query, SELECT * FROM [LinkedServerName].[DatabaseName].dbo.MyPolygon it will return Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object The work around is SELECT * FROM OPENQUERY([LinkedServerName], ‘SELECT * [...]