&nbsp;<BR>Hi All, <BR><BR>I have a store procedure that run every month to drop and recreate tables from the snapshot. It&#039;s been working fine until this month, something really weird happened, after the store procedure was successfully completed, the physical tables weren&#039;t in my database, but when I query a count on those tables I got the result back, and when I describe those tables I got the structure for them as well. Does anyone know why? <BR><BR>TIA <BR><BR>Michael <BR><BR>