Q&A for materials modelers and data scientists
Select 'Select ''' + 'Replace([Name],''.Exported'','''')' + ''' As [DatabaseName], Case WHEN TagName IS NULL Then ''' + 'Null' + ''' WHEN TagName = '''' Then ''Empty'' ELSE ''Unexpected'' End As [Type], Count(*) As [Count] from ' + '[Name]' + '..Tags Where IsNull(TagName,'''')='''' Group By TagName UNION' -- From sys.Databases -- Where Name Like '%.Exported'