err#-2147467259
err desc:Transaction (Process ID 169) 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(125, 76) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-75.95460176467896 45.45724086262233,-76.27457857131958 45.264255114140326,-76.05897188186646 45.04344838585674,-75.30640840530396 45.25265503624703,-75.36134004592896 45.538098589494005,-75.5771666765213 45.4781883781261,-75.58918297290802 45.36637833907405,-75.66368401050568 45.302663445541896,-75.83431541919708 45.29469404344385,-75.95460176467896 45.45724086262233)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Sale_Lease IN ('Sale') AND Type2 IN ('Att/Row/Twnhouse','Condo Apt','Duplex','Fourplex','Garden Home','House','Multi-Family','Single Family','Triplex','Two Apartment House') AND Status='A' AND IDX_Approved=1
Query String: Page=7&PageAction=ViewSubCat&URL=/communities/ottawa-suburbs/
Script Name: /index.asp