Charles,

Thanks for taking the effort to create and share this script. I ran into a problem where column names contained special characters or spaces. They would then be reported in the Skipped results. So I modified the one line of your script that generates the dynamic SQL to use brackets to avoid this. Here is the modified line:

set @sql = N'set @b-2 = (case when exists(select 1 from [' + @SchemaName + '].[' + @TableName + '] where [' + @ColumnName + '] is null) then 1 else 0 end);';

Thanks again.

Lee