View Single Post

   
  #4 (permalink)  
Old 04-19-2008, 09:39 PM
Andy Kent
 
Posts: n/a
Default Re: Table has no rows but has lots of pages

> ALTER FRAGMENT ON mytable INIT IN <dbspacename or fragment expression>;

Does this rebuild the table? OK, not exactly an issue with no rows,
but could be if you still had some left ...

Andy
Reply With Quote