Home Forums Article Discussions Article Discussions by Author Discuss content posted by Lowell Get DDL for any SQL 2005 table RE: Get DDL for any SQL 2005 table
matt_slack
Valued Member
Points: 51
More actions
December 19, 2014 at 3:58 pm
#1765821
When the index is scripted, it doesn't include the schema, i.e. line 566:
' ON [' + [object_name] + ']'
Should be
' ON [' + [schema_name] + '].[' + [object_name] + ']'
And the same further down.
Great script. Thanks