• HI,

    When I execute script1 from the article I get this error:

    Server: Msg 536, Level 16, State 3, Line 210

    Invalid length parameter passed to the substring function.

    My database default collation is set to Latin1_General_CS_AI

    Any idea or resolution would be appreciated.

    Thanks.

    SQL DBA.