• Hi Florian,

    Resolve the issue replacing -

    DECLARE @select VARCHAR(MAX)

    With

    DECLARE @select VARCHAR(8000)

    &

    changing this query

    SELECT @object_id = object_id, @schema_id = schema_id

    FROM sys.tables

    WHERE object_id = OBJECT_ID(@table_name)

    to

    SELECT @object_id = id, @schema_id = schema_id

    FROM sysobjects

    WHERE id = OBJECT_ID(@table_name) and type = 'U'

    But still getting error at schema_id

    Please help on this.

    Thanks

    Vivek