DECLARE @sql nvarchar(300) ? DECLARE ShrinkAllDBs CURSOR READ_ONLY FOR select name from sysdatabases ? DECLARE @name nvarchar(255) OPEN ShrinkAllDBs ? FETCH NEXT FROM ShrinkAllDBs INTO @name WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN SET @sql = N'DBCC SHRINKDATABASE(N''' + @name + N''')' EXEC sp_executesql @sql END FETCH NEXT FROM ShrinkAllDBs INTO @name END ? CLOSE ShrinkAllDBs DEALLOCATE ShrinkAllDBs GO
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....