I am trying to create a SQL view to count the number of point features in a polygon. The following code works when run in a SQL Query, however when I try to create a view using the code I get "Shape.STContains is not allowed, and the column name dbo could not be found or is ambiguous"
SELECT POLYGON.NAME, Count(*)
from Point JOIN
On POLYGON.Shape.STContains(POINT.SHAPE) = 1
GROUP BY POLYGON.NAME
Any assistance would be appreciated.
Are you trying to create the view from ArcCatalog or from within another database client, like SQL Server Management Studio? If the former, have you tried it from a different database client, a non-Esri one?
Please tell me you managed to solve this one?
Then immediately thereafter tell me how you did it.
Have reinstalled servers and .net systems and this one has baffled me.
Thanks hugely in advance