1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| DECLARE @name1 VARCHAR(256)
DECLARE @SQL1 VARCHAR (1024)
DECLARE MyCursor CURSOR FOR
SELECT name
FROM sys.sysdatabases
WHERE version <> '0'
FOR READ ONLY
OPEN MyCursor
FETCH NEXT FROM MyCursor INTO @name1
WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQL1 = '
USE [' + @name1 + ']
select ''ALTER DATABASE [' + @name1 + '] MODIFY FILE ( NAME = ' + @name1 + ' , FILEGROWTH = 0MB , SIZE = '' +
cast(convert(nvarchar(15), floor(size*1.2 * 8)) + N'' KB'' as nvarchar(15)) + '',MAXSIZE = '' +
cast(convert(nvarchar(15), floor(size*1.2 * 8)) + N'' KB'' + '')'' as nvarchar(15)) from sysfiles where fileid=''1''
select ''ALTER DATABASE [' + @name1 + '] MODIFY FILE ( NAME = ' + @name1 + ''+ '_log'+ ' , FILEGROWTH = 0MB , SIZE = '' +
cast(convert(nvarchar(15), floor(size*1.2 * 8)) + N'' KB'' as nvarchar(15)) + '',MAXSIZE = '' +
cast(convert(nvarchar(15), floor(size*1.2 * 8)) + N'' KB'' + '')'' as nvarchar(15)) from sysfiles where fileid=''2'''
EXEC (@SQL1)
FETCH NEXT FROM MyCursor INTO @name1
END
-- Si vous devez vous resservir de votre curseur, pour revenir à la 1e ligne de votre curseur
CLOSE MyCursor
-- Sinon vous pouvez directement le supprimer de la mémoire
DEALLOCATE MyCursor |
Partager