Viewing 15 posts - 2,161 through 2,175 (of 9,703 total)
Ed Wagner (11/17/2015)
Brandie Tarvin (11/17/2015)
Ed Wagner (11/17/2015)
Lynn Pettis (11/16/2015)
Ed Wagner (11/16/2015)
Lynn Pettis (11/16/2015)
************(11/16/2015)
November 17, 2015 at 6:23 am
Ed Wagner (11/17/2015)
Lynn Pettis (11/16/2015)
Ed Wagner (11/16/2015)
Lynn Pettis (11/16/2015)
************(11/16/2015)
November 17, 2015 at 5:37 am
How are your backups being done? Is it a SQL Server maintenance job? Is it a third party tool? Is it a T-SQL job you created?
November 17, 2015 at 5:27 am
Functionally, so long as the linked server exists, you shouldn't have too much of a problem. But remember that it takes a little bit extra CPU to process those linked...
November 17, 2015 at 5:24 am
You can also use "SELECT @sql" which will do the same thing as PRINT but just stick it in the RESULTS tab instead of the MESSAGES tab.
November 17, 2015 at 5:19 am
What kind of concurrency are you looking at? Can it be a day behind? Does it need to be instantly (or near instantly) current?
What kind of backups are you...
November 17, 2015 at 5:18 am
GilaMonster (11/16/2015)
Steve Jones - SSC Editor (11/16/2015)
If you can't do anything else, then you can use the WITH TRUNCATE option to clear the log
Not on SQL 2008. WITH TRUNCATE_ONLY throws...
November 17, 2015 at 5:00 am
GilaMonster (11/17/2015)
November 17, 2015 at 4:54 am
ChrisM@Work (11/17/2015)
Brandie Tarvin (11/16/2015)
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.
Oh gosh, how...
November 17, 2015 at 4:52 am
WayneS (11/16/2015)
Lynn Pettis (11/13/2015)
(think government contracted software development).
My scary story when working with the gov't.
Software contract awarded, specified that all data access has to go through stored procedures.
They sent to...
November 17, 2015 at 4:51 am
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
Viewing 15 posts - 2,161 through 2,175 (of 9,703 total)