I would like to capture the script that was ran by user on yesterday between particular time.
But somehow i am not able to get the desire information.
Can anyone please help me if i am missing anything.
Template: Standard (No option with Default)
LoginName: Name of user
StartTime : Greater than > 2013-03-18 06:00:00.000
EndTime : Less than < 2013-03-18 06:30:00.000.
Please let me know if more information is required.
Nadrek is trying to be funny.
If you did not have an active Trace or Extended Events session running yesterday at the time the batch was run then you will not be able to retrieve it.
For your own understanding, Profiler is a program that can setup new Traces or review the results of previously-captured Traces, i.e. it does not enable us to review previous system activity that was not otherwise being captured in a Trace.
__________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato