USP_RESTOREALLINDEXES_FORTABLE

create procedure bbdw.USP_RESTOREALLINDEXES_FORTABLE(
    @CREATEINDEXSCRIPTS xml
)
as begin
    declare @CREATEINDEXSCRIPT nvarchar(max);

    declare CREATEINDEXSCRIPTS cursor local fast_forward for
        select
            T.c.value('(CREATEINDEXSCRIPT)[1]','nvarchar(max)') AS 'CREATEINDEXSCRIPT'
        from @CREATEINDEXSCRIPTS.nodes('/ITEM') T(c);

    open CREATEINDEXSCRIPTS;
    fetch next from CREATEINDEXSCRIPTS into @CREATEINDEXSCRIPT;

        while @@FETCH_STATUS = 0
        begin

            exec sp_executesql @CREATEINDEXSCRIPT;

            fetch next from CREATEINDEXSCRIPTS into @CREATEINDEXSCRIPT;
        end

        close CREATEINDEXSCRIPTS;
        deallocate CREATEINDEXSCRIPTS;

end