create procedure sp_registerAllInvTables
as
begin
/*}*/

    declare @tntree varchar(64);
    declare @tnitem varchar(64);
    declare @tblowner nvarchar(255);

    DECLARE mycur CURSOR local
        FOR select table_name_tree, table_name_item, tbl_owner from inv_table_map;
        
    declare @updSql varchar(255);    
    

    OPEN mycur
    FETCH NEXT FROM mycur INTO @tntree, @tnitem, @tblowner; -- get first
    WHILE @@FETCH_STATUS = 0
    BEGIN
                
        
        EXECUTE  sp_register_newinvtrtbl @tntree, @tblowner;
        EXECUTE  sp_register_newinvitmtbl @tnitem, @tblowner;

        
        FETCH NEXT FROM mycur INTO @tntree, @tnitem, @tblowner; -- get next

    END

    CLOSE mycur
    DEALLOCATE mycur


end;
GO
GRANT EXECUTE ON  [dbo].[sp_registerAllInvTables] TO [ca_itrm_group]
GO