Viewing 15 posts - 2,176 through 2,190 (of 9,715 total)
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
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
Viewing 15 posts - 2,176 through 2,190 (of 9,715 total)