I have had this problem. In my stored proc I was using a temp (#) work table. I changed this to a permanent table that was created and...

Thanks. I think your EMPTYFILE approach is essentially the same as Tim's DTS job. By moving the data pages from one file to another seems to resolve the...

Tim,

You didn't mention if RedGate came back with any differences. My database is 34.2Gb total - 20.8G used and 13.3G Unused. I ran "DBCC UPDATEUSAGE(0)" and it came...

We have the same problem, unfortunately I can't take your approach i.e. new database and copy as used space = 19Gb, free = 15Gb. Does anyone have any other...