Daniel Hutmacher has released a new tool:
I designed my sp_ctrl3 procedure from the ground up to be a development tool that I can install on any dev environment that I use regularly. I wanted a detailed overview of a specific database object as well as copy-paste-friendly T-SQL code. For instance,
No “length” column on an int column
Proper scale/precision values on datatypes
“NULL” or “NOT NULL” instead of “yes” or “no”
Identity column syntax
“nvarchar(50)” instead of “nvarchar”, “100”
Column defaults
Complete index definitions
GRANT/DENY permission statements
The object_id of the object in sys.objects
If you use sp_help a lot, this looks like a good supplement.