You can use triggers to log changes.

>
>I need to a way on how to query my sql server database on the following
>by my client who know nothing on database query. I need to give them
>a simple easy using tool for them to check
>
>01) of any changes that other user modify, which related table is affected
>02) if data is modify, what business rule is affected
>03) any deletion, which related table is related or affected
>
>Anyone done similar stuff on this before, is it related
>to data dictionary ?
>
>Please advise and assist me on how to go about doing it.
>Thank you