Thanks guys for all the contributions, I am glad that this script has been useful. Its wonderful to see the engagement resulting in a better solution.

Hi Rahul,

Glad my article was of use to you, I appreciate the positive feedback.

Thanks.

Trevor

Hi,

The error seems to point to something that has been excluded in the create procedure statement you ran to generate the proc.

Please navigate to the procedure on the database to...

Hi,

Are the missing databases online? I have included a filter to only pick active databases.

If the above does not solve your issue, please check if the name returned for the...

Hi,

Please change the ALTER PROCEDURE statement to CREATE PROCEDURE, and also make sure to specify the database on which you created the procedure 'EXEC [database].[dbo].[proc_ShowDbSpaceUsage]'

Thanks.

Good suggestion, I have applied as per below to solve the empty result set issue:

Check this:

Please let me know if there is a way to suppress empty result sets in...

I am not sure if you can control the output of the for each query to limit it to only databases that contain the search table, running the statement as...