Viewing 15 posts - 7,021 through 7,035 (of 9,643 total)
Sorry, I am enroute from Florida to New Hampshire (1500 miles) and have not had a chance to be online. If you add the .DLL to "C:\Program Files\Microsoft SQL...
November 4, 2008 at 5:37 pm
I don't know about innovative, but you are welcome and I'm glad I could be of some help.
November 1, 2008 at 4:30 pm
Are you doing a full incremental refresh? Without linked servers I think you need a windows service or application that transfers the data.
October 31, 2008 at 2:50 pm
Here's the table list you need:
SYSJOBS SJ JOin
SYSDBMAINTPLAN_JOBS MPJ On
SJ.job_Id = MPJ.job_Id JOin
sysdbmaintplans MP On
MPJ.plan_Id = MP.plan_id Join
sysjobsteps JST On
SJ.job_Id = JST.job_Id Join
sysjobschedules JS On
SJ.job_id = JS.job_id join...
October 31, 2008 at 2:34 pm
I don't think you do set-based using a function since the function is referencing the table it is updating.
October 31, 2008 at 1:49 pm
I don't know that there is a way to do what you want because you need the users to have permissions on the "internal" reports so as long as they...
October 31, 2008 at 1:32 pm
Can you post the trigger code? It's hard to debug/tune something you can't see.
I'm also not sure what you mean. Do you mean that if someone...
October 31, 2008 at 1:29 pm
I have to ask, why do you need this 2 character code if the you already have a unique key and have added an identity field which is the primary...
October 31, 2008 at 1:22 pm
This should only update rows in tbl_BPMHDR that have a promise date < ANY cutoff date. Are you sure you don't have a part of the join missing? ...
October 31, 2008 at 1:17 pm
Instead of X(column) do X(ProductId) or something else. And the [XPATH] needs to be replaced with the XPath expression that will navigate to the product id.
October 31, 2008 at 11:10 am
Where I put "column list" you need to supply the list of columns you want to return. That was just a place holder since you did not post any...
October 31, 2008 at 10:44 am
GilaMonster (10/31/2008)
That's the ideal. Probably 2/3 of the article would have to be for those without backups though.
[sarcasm]
What? You mean someone may not have backups? That never happens...
October 31, 2008 at 8:47 am
I have written a component that does something similar and you can download it and the source here: http://cid-d959306fcfdbac21.skydrive.live.com/self.aspx/Public/SSIS%20Components/JDCSSISLogging.zip. My component is an extension of the code in this...
October 31, 2008 at 7:53 am
If the keys are different then in my opinion they should be different tables.
October 31, 2008 at 7:44 am
Viewing 15 posts - 7,021 through 7,035 (of 9,643 total)