Sorry Keplan, just realized I misread your post a bit. When I check my existing Pivots, this option is available using standard ODBC and OLE DB connections. I suspect it might have something to do with
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.