• odeddror (8/14/2015)


    All I want is to count actual column count per all tables (and schema too)

    row count is sometime can be misleading (nulls, 0's or ' ' spaces)

    Your sproc produce an error

    Msg 537, Level 16, State 3, Procedure EE_PROFILE_TABLE, Line 179

    Invalid length parameter passed to the LEFT or SUBSTRING function.

    Thanks,

    Ed Dror

    Tell you what, instead of telling us what the output should be, show us what it should look like with some examples.