- DECLARE @name sysname
- DECLARE @LaRequette varchar(8000)
- DECLARE @DateJour varchar(20)
- DECLARE @TauxEspaceLibre int
-
- -- VALEUR A CHOISIR CONCERNANT LE TAUX D'ESPACE LIBRE VOULU
- SET @TauxEspaceLibre = 10
-
- SET @DateJour = REPLACE(CONVERT(VARCHAR, GetDate(), 102), '.', '_')
- PRINT '---------------------------------------------------------------------'
- PRINT '-- DATE COMPACTAGE LANCE : '+ @DateJour
- PRINT '---------------------------------------------------------------------'
-
- DECLARE TESTCURSEUR CURSOR
- FOR SELECT Master.dbo.sysdatabases.name FROM Master.dbo.sysdatabases
- WHERE Master.dbo.sysdatabases.name NOT IN ('tempdb', 'model', 'pubs')
-
- OPEN TESTCURSEUR
- FETCH NEXT FROM TESTCURSEUR
- INTO @name
-
- WHILE @@FETCH_STATUS = 0
-
- BEGIN
- PRINT ''
- PRINT '---------------------------------------------------------------------'
- PRINT '-- COMPACTAGE EFFECTUE SUR LA BASE DE DONNEES : '+ @name
- PRINT '---------------------------------------------------------------------'
-
- SET @LaRequette = 'DBCC SHRINKDATABASE (['+ @name +'], '+ CONVERT(VARCHAR(10), @TauxEspaceLibre) +')'
- PRINT 'Requette : '+ @LaRequette
- EXECUTE (@LaRequette)
-
- PRINT '---------------------------------------------------------------------'
-
- FETCH NEXT FROM TESTCURSEUR
- INTO @name
-
- END
-
- CLOSE TESTCURSEUR
- DEALLOCATE TESTCURSEUR
DECLARE @name sysname
DECLARE @LaRequette varchar(8000)
DECLARE @DateJour varchar(20)
DECLARE @TauxEspaceLibre int
-- VALEUR A CHOISIR CONCERNANT LE TAUX D'ESPACE LIBRE VOULU
SET @TauxEspaceLibre = 10
SET @DateJour = REPLACE(CONVERT(VARCHAR, GetDate(), 102), '.', '_')
PRINT '---------------------------------------------------------------------'
PRINT '-- DATE COMPACTAGE LANCE : '+ @DateJour
PRINT '---------------------------------------------------------------------'
DECLARE TESTCURSEUR CURSOR
FOR SELECT Master.dbo.sysdatabases.name FROM Master.dbo.sysdatabases
WHERE Master.dbo.sysdatabases.name NOT IN ('tempdb', 'model', 'pubs')
OPEN TESTCURSEUR
FETCH NEXT FROM TESTCURSEUR
INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ''
PRINT '---------------------------------------------------------------------'
PRINT '-- COMPACTAGE EFFECTUE SUR LA BASE DE DONNEES : '+ @name
PRINT '---------------------------------------------------------------------'
SET @LaRequette = 'DBCC SHRINKDATABASE (['+ @name +'], '+ CONVERT(VARCHAR(10), @TauxEspaceLibre) +')'
PRINT 'Requette : '+ @LaRequette
EXECUTE (@LaRequette)
PRINT '---------------------------------------------------------------------'
FETCH NEXT FROM TESTCURSEUR
INTO @name
END
CLOSE TESTCURSEUR
DEALLOCATE TESTCURSEUR