Viewing 2 posts - 1 through 2 (of 2 total)
Yes, its possibile, you execute update in systabases alter the value of column "category" for 0, move database and restore the value of 1.
March 25, 2007 at 2:00 pm
#696783
Hi, use the dbcc shrinkfile with option 'emptyfile' in the .ndf file to merge data in .mdf file.
November 7, 2006 at 6:36 pm
#670446