Do be sure to update your statistics also, though, esp. when restoring SQL to a different version.

It's more common to use SUM(... THEN 1 ELSE 0 END), rather than COUNT, (and clearer, at least to me), so I've done that below.

SELECT

You have CREATE USER in the code twice (once IF'd and once not).

IF SUSER_ID('[Domain\IT Developers]') IS NULL
  CREATE LOGIN [Domain\IT Developers] FROM WINDOWS WITH...

This is fairly typical of the results I see for a child table.  The clus index is ( parent_identity, child_identity ) and the non-clus index is ( child_identity ).

EXEC sp_MSforeachdb '
IF LEN(''?'') = 9 AND RIGHT(''?'', 5) = ''_prod''
BEGIN
    USE [?];
    IF EXISTS(SELECT 1 FROM sys.columns WHERE object_id =...