ERROR: select * from (select distinct listingID, name, replace(name, '', 'aaaa') orderByStr, metroAreaID, metroName, metroCode, cityName, categoryID, categoryName, blurb, number, streetName, mapnum, mapName, bookName, webIconFile, phone, departmentPhone, closed, pricesOrFees, Replace(dbo.fxListingAttributes(listingID, categoryID, mapID, bookID), '
', ', ') Attributes, (select count(listingID) from vwRadarsListings rl where rl.listingID=vwLS.listingID and publishON <='2/24/2018 3:14:12 PM') radarsCNT, (select count(listingID) from ListingCategoryBookBlurb bl where bl.listingID=vwLS.listingID and usePrint=1) bookCNT, lat,long , -1 dist from vwListingsSearch vwLS where (1=1) and metroCode='NY' and mapID=50238) tbl where 1=1 order by name
System.IO.IOException: There is not enough space on the disk. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32 count) at System.IO.FileStream.FlushWrite(Boolean calledFromFinalizer) at System.IO.FileStream.Dispose(Boolean disposing) at System.IO.Stream.Close() at System.IO.StreamWriter.Dispose(Boolean disposing) at System.IO.StreamWriter.Close() at NFT.dataAccess.logTime(DateTime startDate, DateTime endDate, String str) in e:\nft\App_Code\dataAccess.cs:line 30 at NFT.dataAccess.fetchDS(String sql) in e:\nft\App_Code\dataAccess.cs:line 173 at newyork.updateSearch(String addrFrom) in e:\nft\Search.aspx.cs:line 500