err#-2147467259
err desc:Transaction (Process ID 1017) 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(76,82) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.3438949584961 45.53256738748246,-75.30921936035156 45.48011419562789,-75.30235290527344 45.47698470876219,-75.13652801513672 45.52607354310015,-75.16021728515625 45.57439862270548,-75.21926879882812 45.58256890575484,-75.31436920166016 45.55276566433722,-75.3438949584961 45.53256738748246)))', 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: Page=12&PageAction=ViewSubCat&URL=/communities/rockland/
Script Name: /index.asp