Viewing 15 posts - 2,101 through 2,115 (of 18,926 total)
Roy Ernest (10/12/2011)
October 12, 2011 at 10:52 am
SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))
October 12, 2011 at 10:45 am
jared-709193 (10/12/2011)
MysteryJimbo (10/12/2011)
Ninja's_RGR'us (10/12/2011)
Once you tell...
October 12, 2011 at 10:07 am
Run the report from VS (should be easier to spot in the trace, but either will do).
You point the trace to whatever sql server the report gets the data from.
October 12, 2011 at 10:06 am
Just a PS. Doesn't work on 2K5 :angry:
October 12, 2011 at 9:31 am
You should sign up for his newsletter... great stuff every week.
October 12, 2011 at 9:25 am
I've yet to see a single client trade data quality for a little extra performance (never had a lot with correct tuning on the system).
Once you tell them it's certain...
October 12, 2011 at 9:04 am
http://msdn.microsoft.com/en-us/library/ms174997.aspx
But if you don't see anything in the GUI I really don't expect you to see anything in there.
October 12, 2011 at 8:58 am
Well in this case without backup you can't do anything unless maybe you have verbose logging on the agent.
You could see something similar to this :
Date10/12/2011 10:30:00 AM
JournalSQL Agent...
October 12, 2011 at 8:49 am
If you have msdb in full recovery and a full backup prior to the delete then you can take a log backup and restore msdb to a new name before...
October 12, 2011 at 8:37 am
Just a PS, that's why Paul Randal's always does a job to cycle the error logs daily and then keep 99 days.
You can more easily spot what and when something...
October 12, 2011 at 8:35 am
CoolCodeShare (10/12/2011)
I believe that your backup file is corrupted one. Please take back up again.
Please use RESTORE VERIFYONLY option to make sure if the back up is not corrupted.
You...
October 12, 2011 at 7:17 am
And I've seen a virus with this exact behavior (was 60 secs but still).
I've also seen a screensaver peg the cpus at 100%.
Both of which could only be seen while...
October 12, 2011 at 6:44 am
Viewing 15 posts - 2,101 through 2,115 (of 18,926 total)