Thank you!!

This process worked great except my master database collation was different from my new re-created database so I had to modify the script.

I was getting error

"Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."

so i modify these two parts of the script

-- Add the tables that have no Foreign-Key relationships...

INSERT INTO #Hierarchy

SELECT -1, [name] COLLATE SQL_Latin1_General_CP1_CI_AS, ' - '

FROM dbo.sysobjects

WHERE [name]COLLATE SQL_Latin1_General_CP1_CI_AS NOT IN (SELECT DISTINCT Parent FROM #Hierarchy)

AND [Name]COLLATE SQL_Latin1_General_CP1_CI_AS NOT IN (SELECT DISTINCT Child FROM #Hierarchy)

AND xtype = 'U'

-- =====================================================

-- Identify tables that will require identity insert...

-- =====================================================

UPDATE #TableInfo

SET IdentityField = 'Y'

FROM dbo.sysobjects

INNER JOIN dbo.syscolumns

ON dbo.sysobjects.id = dbo.syscolumns.id

WHERE dbo.syscolumns.status = 0x80

AND dbo.sysobjects.name COLLATE SQL_Latin1_General_CP1_CI_AS = #TableInfo.TableName

Just thought I would make the post in case anyone else has the same problem