Viewing 6 posts - 1 through 6 (of 6 total)
Eben (4/29/2009)
Just run dbcc shrinkfile(file_id, size) on the database you want to amend.
To everyone reading this thread: the point is that the command above and all those like it...
April 29, 2009 at 7:58 am
Yes, it seems that the "create a new blank database then script all the objects to that DB" is the only option.
Unfortunately for me that option didn't work. There...
November 4, 2008 at 10:11 am
Matt Miller (5/28/2008)
Setting the size of the files during the ALTER DATABASE statement will both change the initial size AND shrink the files.
Assuming that you mean the command:
ALTER DATABASE BLS_NewCo...
May 28, 2008 at 9:06 pm
rbarryyoung (5/28/2008)
However, you can shrink the individual database files to a smaller size than their initial size by using the DBCC SHRINKFILE...
May 28, 2008 at 8:33 pm
When this happened to me the cause was the registry key: HKLM\Microsoft\Jet\4.0\Engines\Excel\win32
was pointing to an invalid path. Once I fixed the path to point to the actual location...
October 23, 2007 at 11:04 am
I'm trying to follow this procedure but get this error when working on the Data Flow task, after adding the OLEDB Source and double-clicking it, when I drop the combo...
August 3, 2007 at 5:47 pm
Viewing 6 posts - 1 through 6 (of 6 total)