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