In Microsoft SQL Server 2000, if you run the DBCC SHRINKFILE statement after you run the DBCC SHRINKFILE statement together with the EMPTYFILE option, the second DBCC SHRINKFILE statement does not have any effect.
Read More - Register for Free Membership
