tsql - 如何抑制 `DBCC SHRINKFILE` 的输出？

Question

为了隐藏DBCC SHRINKFILE的输出我试过:

CREATE TABLE #Swallow(DbId int, Fileld int, CurrentSize int, MininumSize int, UsedPages int, EstimatedPages int)
INSERT INTO #Swallow EXEC('DBCC SHRINKFILE(''filename'', 0, TRUNCATEONLY)')

但它返回以下错误:

Cannot perform a shrinkfile operation inside a user transaction. Terminate the transaction and reissue the statement.

如何才能做到这一点？

Answer 1

似乎有一个 WITH NO_INFOMSGS选项:

DBCC SHRINKFILE('filename', 0, TRUNCATEONLY) WITH NO_INFOMSGS

引用: http://ss64.com/sql/dbcc_shrinkfile.html