March 20, 2013 at 12:10 am
Hello All,
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.
March 21, 2013 at 2:06 pm
To capture activity that happened yesterday, today, please look up DBCC TIMEWARP. Be certain to study the clarification on the 13th parameter:
http://www.sqlservercentral.com/Forums/FindPost866665.aspx
Alternately, generate a trace to capture only what you need and then ask the user to try again while you're running it.
March 22, 2013 at 2:45 pm
EasyBoy (3/20/2013)
Hello All,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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy