Tu peux t'inspirer de ces deux bouts de code : 
EXECUTE sp_msforeachdb 'use [?]; IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = ''M8'' AND TABLE_SCHEMA = ''dbo'') TRUNCATE TABLE dbo.M8'
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| DECLARE @SQL_ex NVARCHAR(500)
DECLARE CURSOR_Modif_Param CURSOR FOR
SELECT SQL='USE ['+name+'] ; DBCC SHRINKDATABASE(N''' + name + ''' )' from sys.databases
OPEN CURSOR_Modif_Param
FETCH NEXT FROM CURSOR_Modif_Param INTO @SQL_ex
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @SQL_ex
EXECUTE sp_executesql @SQL_ex
FETCH NEXT FROM CURSOR_Modif_Param INTO @SQL_ex
END
CLOSE CURSOR_Modif_Param
DEALLOCATE CURSOR_Modif_Param
GO |
Partager