Untitled

DECLARE @sqltext VARCHAR(MAX)
DECLARE @UpdateValue VARCHAR(30) = ''

SELECT @sqltext = ISNULL(@sqltext,'') + 'UPDATE ['+o.name + '] SET [Dimension Set ID] = 0; 
'
FROM sys.syscolumns c
    JOIN sys.sysobjects o ON c.id=o.id
WHERE UPPER(c.name) = 'Dimension Set ID'

PRINT @sqltext
--EXEC sp_executesql @sqltext