stored procedure for all tables

Question

hi everyone, please help me I want to update data field "Status" on All table in a database with stored procedure. so when I click button Lock. field "status" on a table change "Y" but before change data in all tables automatic was copy data. are you understand? sorry for my bad english.