Viewing 15 posts - 2,191 through 2,205 (of 9,720 total)
balasach82 (11/16/2015)
Is it because of Excel 2003. If I point it to Excel 2010/2013, would it be resolved?
I don't know. You'd have to do a google search for the max...
November 16, 2015 at 12:10 pm
Glad I could help.
November 16, 2015 at 12:07 pm
It depends on the power users and what they were trying to do.
If they were just writing reports, we'd probably give them access to the SSRS adhoc reporting tools. On...
November 16, 2015 at 11:45 am
Looks like you either need to split the column to multiple smaller columns or do a LEFT() on the column to fit it into Excel.
Alternatively, you could export it as...
November 16, 2015 at 11:42 am
Column run_duration is in sysjobhistory.
EDIT: You also already have the start time. It's column run_time in sysjobhistory. Just pull it separately. Do a CASE to check the job status, the...
November 16, 2015 at 11:38 am
Jeff Moden (11/16/2015)
Last but not least, there may have been another borderline equipment failure such a switch or router going bad.
Or a disk controller is going. Or someone messed...
November 16, 2015 at 11:35 am
robert.sterbal 56890 (11/16/2015)
One of the things that makes people turn away from a forum is when bed behavior isn't addressed.
Bad behavior is policed by this wonderful thing called a REPORT...
November 16, 2015 at 11:31 am
I wouldn't try to restore system databases to the new server as it could cause multiple issues when those dbs upgrade. You shouldn't really need much out of master, but...
November 16, 2015 at 11:23 am
I think understanding security is a big must. I don't know if you are assuming that as part of DBA management, but regardless of what kind of DBA you are,...
November 16, 2015 at 11:17 am
robert.sterbal 56890 (11/16/2015)
-------------------------------------------------------
You are asking a question that could be looked up easily...
November 16, 2015 at 11:13 am
And if you happen to already be backing up the transaction log, then you may have bigger issues than just a full disk drive. Such as a runaway process that's...
November 16, 2015 at 11:00 am
Lynn Pettis (11/16/2015)
Sorry, got snippy with an OP.50 lashes with a noodle please.
My Patented Wet Noodle <tm> no less. Shame.
EDIT: BTW, I'm teasing you, Lynn.
November 16, 2015 at 10:57 am
Ed Wagner (11/16/2015)
GilaMonster (11/16/2015)
Brandie Tarvin (11/16/2015)
Ed Wagner (11/16/2015)
BrainDonor (11/16/2015)
djj (11/16/2015)
November 16, 2015 at 9:24 am
Ed Wagner (11/16/2015)
BrainDonor (11/16/2015)
djj (11/16/2015)
November 16, 2015 at 8:17 am
I've been looking at the data (i.e., the column names) and I just realized this is Adventure works. So I looked again at the problems, actually reading them this time...
November 13, 2015 at 12:59 pm
Viewing 15 posts - 2,191 through 2,205 (of 9,720 total)