This is good, except I needed to change the data type names to lower case in the declaration statements. I suspect this may be because my collation is CS.

Seems to be rife with syntax errors.

When I ran the script, I received this error:

Msg 102, Level 15, State 1, Line 27

Incorrect syntax near '('.

Line 27:

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'LIMITED') AS i

Please help.

Thanks.

Scott

Thank you, Wayne,

I looked at a couple of table scripts and didn't notice anything wrong. What kind of issues did you see if you don't mind?

Scott

Why would you need to recreate system objects though?

Why didn't they bother to include a copy of a working version of the script? I have yet to see a script on this site that works as advertised...