Hi,

Just as an update the server restarted last night due to windows patching and has now returned all the table swell that I was seeing to free space in the...

Im right clicking the table in ssms and selecting properties then storage

Im also looking at the standard database report top tables by usage ( i think thats what it was...

Thanks for the response , thats whats strange test was a copy back from live so should be an exact copy...

Thanks again

Frant101