Trigger returns Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= or when the subquery is

I have this trigger, and it throws this error:

Copy structure table with this trigger to new table (SQL Server)

I want to copy the structure of a table + trigger to a new table.
I already use this method, but I got some errors.