err#-2147467259
err desc:Transaction (Process ID 346) 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(37,50,76,52,93) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.67108154296875 45.39977585527912,-75.66198348999023 45.398570512042,-75.64241409301758 45.39977585527912,-75.64756393432617 45.39386942773064,-75.65614700317383 45.3796432523812,-75.66884994506836 45.377231681380145,-75.66421508789062 45.36999635126154,-75.66696166992188 45.36879037291228,-75.68464279174805 45.37674935483764,-75.68841934204102 45.38301927899065,-75.68326950073242 45.386877348270374,-75.67880630493164 45.388203498774,-75.67108154296875 45.39977585527912)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Sale_Lease IN ('Sale') AND Status='A' AND IDX_Approved=1
Query String: PageAction=ViewCategory&URL=/alta-vista/
Script Name: /index.asp