ok i understood but here is the situation:

an entry was changed in the database and i need to identify the workstation (host_name) it was made from.

what can i do?

Thanks..

is there a way i can use the profiler to view transactions log file

no i only use redgate to view log

thanks for the reply

how can i use this to see last week database log inculding the workstation (host_name)?

the profiler shows the host name but i need to view old transaction...