err#-2147467259
err desc:Transaction (Process ID 679) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT ID FROM PropertiesFreeholdAndCondos WHERE Board IN(41, 20, 14, 82, 125) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-80.37560105323792 43.28970176878268,-80.4957640171051 43.201171681272456,-80.54726243019104 43.17313537107136,-80.49233078956604 43.04279812270172,-80.20737290382385 43.0819284373621,-80.10162949562073 43.16762672558954,-80.23003220558167 43.28920196020127,-80.37560105323792 43.28970176878268)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewSubCat&URL=/communities/brant-county/
Script Name: /index.asp