Viewing 15 posts - 1,231 through 1,245 (of 1,492 total)
Filemon and Regmon can be helpful to see file and registry permissions issues.
You also might want to check Local Security Policy (under Administrative Tools on the start menu) and see...
November 13, 2009 at 6:48 am
Part of this depends on whether they are looking for subscriptions having run or failures.
I tend to look only at exceptions, and use MOM (or SCOM) to monitior the windows...
November 11, 2009 at 10:08 pm
Karen Roslund (10/29/2009)
stevefromOZ (10/29/2009)
To answer your last question, yes, you can see the query, either by running a sql trace, or even simpler, in the processing dialog window, if you...
November 11, 2009 at 7:02 am
Alvin Ramard (11/10/2009)
GSquared (11/10/2009)
Steve Jones - Editor (11/10/2009)
Hammers aren't fun for technical equipment on the fritz. Now a slingshot.....Depends on how you define the word "hammer"[/u].
The one on the...
November 10, 2009 at 1:17 pm
Luke L (11/6/2009)
jcrawf02 (11/6/2009)
So then we've finally found a definitive benefit of RBAR - environment control
Jeff's gonna be pissed...
Though I suppose if you get it to raise the temps enough...
November 6, 2009 at 8:35 am
It looks like there is a begin time, and end time, along with the various components.
60000 = 60 seconds on one of my reports.
Convert TimeDateRetrieval, TimeProcessing, and TimeRendering.
They should add...
November 4, 2009 at 11:51 am
Can you also simplify the groupings?
And possibly open it up in BIDS on another machine? I'd think this would be better than just running the query from other machines.
We had...
November 3, 2009 at 6:54 am
Jeff Moden (11/2/2009)
pleasehelpme (11/2/2009)
gilamonster,it's not your business how people like to answer the questions in the interview. Stop whining ok, you are annoying.
Heh... nah... what's realy annoying is people in...
November 3, 2009 at 6:38 am
This is the best document I've seen for setup.
Greg E
October 28, 2009 at 8:40 am
It seems like its giving problem in the join. Not sure if we can use ASWTEST.S1012A5CI.C1480BFPD.XROHUB.XUBCUNO direclty in the join since its not used above in the query.
Which is why...
October 22, 2009 at 1:45 pm
ASWTEST.S1012A5C.IC1480BFPD.XROHUB.XUBCUNO
I think Randy is right.
This doesn't look right.
AS400 Name
DB2 instance name
Table name
Column name
Greg E
October 22, 2009 at 1:13 pm
SELECT XUBRNAM
This is still not qualified.
One other thing I would try and verify -
that each query (outer and exists) returns results from each of the sources when run.
The field...
October 22, 2009 at 11:52 am
UPDATE ASWTEST.S1012A5C.IC1480BFPD.XROHUB
SET XUBRNAM =
(SELECT XUBRNAM
FROM [DataWarehouse480].[dbo].[Temp_SalesRep] T1
WHERE T1.XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB .XUBCUNOAND EXISTS
(SELECT 1 FROM [DataWarehouse480].[dbo].[Temp_SalesRep] T1 WHERE T1.XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB .XUBCUNO))
I don't know if the...
October 22, 2009 at 9:42 am
UPDATE ASWTEST.S1012A5C.IC1480BFPD.XROHUB T2
SET T2.XUBRNAM =
(SELECT XUBRNAM
FROM [DataWarehouse480].[dbo].[Temp_SalesRep] T1
WHERE T1.XUBCUNO = T2.XUBCUNO
AND EXISTS
(SELECT 1 FROM [DataWarehouse480].[dbo].[Temp_SalesRep] T1 WHERE T1.XUBCUNO = T2.XUBCUNO))
See if using AND instead of WHERE...
October 22, 2009 at 6:33 am
When I get a bit more time, I'll have to try your structure out.
I'm missing where this is managing parms at any lower that a DistributionID level.
But it wouldn't be...
October 20, 2009 at 11:54 am
Viewing 15 posts - 1,231 through 1,245 (of 1,492 total)