> > 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
usually clears it up.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com