可从早上到现在，观察MDF文件大小没有变化。
早上磁盘空间剩余1.8G。现在1.67G。因为是服务系统，不能停服务。
是否跟不能停服务有关系？或者磁盘剩余空间太小了？
CREATE PROCEDURE dbo.deletetable
AS
DECLARE @Name as NVARCHAR(128)
DECLARE curObject CURSOR FOR
select name from sysobjects where type='U' and name like 'abc2012%'
OPEN curObject
FETCH NEXT FROM curObject INTO @Name
WHILE(@@FETCH_STATUS=0)
BEGIN
print 'drop table '+@Name
exec('drop table '+@Name)
FETCH NEXT FROM curObject INTO @Name
END
close curObject
deallocate curObject
GO
exec deletetable
然后
DUMP TRANSACTION ** WITH NO_LOG
BACKUP LOG ** WITH NO_LOG
收缩
DBCC SHRINKDATABASE('abc') 
