err#-2147467259
err desc:Transaction (Process ID 674) 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(20,16) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-80.36087036132812 43.40189836698059,-80.34722328186035 43.404766879781135,-80.34327507019043 43.39170157541866,-80.34576416015625 43.39114023431447,-80.34700870513916 43.390079909154544,-80.3633165359497 43.398561991030235,-80.36087036132812 43.40189836698059)))', 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=ViewSubCat&URL=/communities/preston/
Script Name: /index.asp