DB02 information is inaccurate
We are running SAP BW on SQL Server 2005. After deleting some rows from a table, DB02 is showing Total Rows = 0. However SE16 shows there are thousands of rows in the table.
What causes this incorrect reporting in DB02 and how can I get it resolved?