FIX: SEM - Edit Devices Dialog Displays Negative Device Size

• Microsoft SQL Server, versions 6.0 and 6.5

SYMPTOMS

SQL Enterprise Manager (SEM) can sometimes show a negative number for the size of a device in the Edit Devices dialog. This problem only 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.

WORKAROUND

To work around this problem, use the DISK RESIZE command to manually increase the size of the device.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

MORE INFORMATION

If you have already applied SQL Server 6.5 Service Pack 3, you may still experience this problem if the client-side copy of Sqlew.exe has not been refreshed from the SQL Server.