down voteaccept YAAYYYYYYY. Got it. It seems that the STContains function won't operate with a DBO schema in front of the field name. If you add the database name to the query it works. Should look like this. USE MyDatabase Select dbo.PointTab.*, dbo.PolyTab.Name from dbo.PointTab Inner Join dbo.PolyTab On PolyTab.GeometryCol.STContains(dbo.PointTab.GeometryCol) = 1
... View more