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 |