> > The Enterprise Manager still reports the size as a negative number (when
> >you edit the device), but shows the true size in the graph, and also when
> >you select "Manage->Database Devices" from the menu.
>
> Here is what Microsoft says about it...
>
> Why does SQL Enterprise Manager (SEM) sometimes show a negative number for
> the size of a device?
>
> This problem occurs if the device being edited is on a drive
> that has more than 2 gigabytes of free space. When
> this problem occurs, the size of the device cannot be changed
> in the dialog box.
>
> To work around this problem, use the DISK RESIZE command to
> manually increase the size of the device.
>
> Does that answer your question?
I've seen it show negative numbers from a dirty shutdown. A DBCC
CheckDB()
usually clears it up.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com