System procedures always operate at isolation level 1, regardless of the isolation level of the transaction or session.
User stored procedures operate at the isolation level of the transaction that executes it. If the isolation level changes within a stored procedure, the new isolation level remains in effect only during the execution of the stored procedure.