0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

Select 'Select ''' + Replace([Name],'','') + ''' As [DatabaseName], '
+ 'Count(*) As [Count], (SELECT COUNT(*) FROM [' + [Name] + ']..Users fun WHERE fun.AccountId Is NULL) As [Nulls] '
+ 'From [' + [Name] + ']..Users fu Join Users u ON fu.AccountId=u.AccountId '
+ ' UNION ALL '
From sys.Databases
Where Name Like '%'

fork query

edited feb 16 14

created feb 16 14 Mark Hurd