Re: CallsOnline and tempdb

Dale E. Reed Jr. ( (no email) )
Sat, 12 Apr 1997 08:11:32 -0700

David Edwards wrote:

> > 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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |