BUG: SQLDMO: DBFile.Shrink and LogFile.Shrink with SQLDMOShrink_EmptyFile Generates Invalid DBCC Command

ID: Q247307

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55507 (SQLBUG_70)

SYMPTOMS

When a SQL Distributed Management Object (DMO) program executes a statement like this:


DBFile.Shrink -1, SQLDMO.SQLDMOShrink_EmptyFile

-or-


LogFile.Shrink -1, SQLDMO.SQLDMOShrink_EmptyFile

The following error message occurs:

[SQL Server] Parameter 3 is incorrect for this DBCC statement.

CAUSE

The DBCC ShrinkFile statement generated by SQL DMO contains both the size and EMPTYFILE option even though there is no need to specify the second parameter (size) with the EMPTYFILE option.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug