Created/ModifiedBy columns as INT?

Mar 14, 2011 at 10:47 PM

I generally want @StrictUserContext = 0 b/c my app has internally managed security.

I like having the columns specified by @BaseTableDDL, except I'm always using an INTEGER which is a FK to a Users table rather than a [var]char value.

Req: Make @BaseTableDDL a tinyint (or use another variable) to specify that the CreatedBy and ModifiedBy columns be INT (nullable) rather than [var]char.

P.S.  I love this script!