Generate 'No empty TagNames in any existing database'

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

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'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results