Viewing 15 posts - 1,561 through 1,575 (of 3,738 total)
Thanks and don't you clear out your staging after the initial load to Staging and the inital load to the DW is complete.
April 3, 2012 at 1:28 pm
Any thought, ideas, opinions, experiences,etc would be greatly appreciated.:-)
April 3, 2012 at 1:17 pm
I took Parts of his OPEN QUERY Statements converted to Data Tranformation Task and loaded 178 tables in SSIS with the initial load and eliminated the slow OPEN QUERY Code.
He...
April 3, 2012 at 12:56 pm
It appears that the person of interest has no intention of ever clearing the Staging. :hehe:
They will retain the Initial Load and each incremental load.
THe staging is never cleared...
April 3, 2012 at 10:39 am
Listed below is the script that I have used to configure 5 servers in the past 6 months. Excluding the one that it is not working on.
I also listed some...
April 3, 2012 at 5:21 am
Lowell (4/2/2012)
Lynn Pettis (4/2/2012)
What has me slightly confused is you talk about using Database Mail, but the code you show is using...
April 3, 2012 at 4:42 am
SQLKnowItAll (4/2/2012)
In my neverending search for knowledge... I found this article. Welsh, does this help at all?
I had found another article similar to this.
I got an error when I...
April 2, 2012 at 4:26 pm
Lynn Pettis (4/2/2012)
What has me slightly confused is you talk about using Database Mail, but the code you show is using CDONTS....
April 2, 2012 at 4:17 pm
Welsh Corgi (4/2/2012)
SELECT *
FROM sysmail_event_log
Nothing but start & stop DB Mail
SELECT *
FROM sysmail_allitems
I found the items were listed as failed.
So I check the Windows...
April 2, 2012 at 4:13 pm
Lowell (4/2/2012)
SQLKnowItAll (4/2/2012)
Yup! Stepping away and observing because this is clearly not what I thought... 🙂
IIt seems to me the issue's more related to the service broker not processing the...
April 2, 2012 at 4:00 pm
Lynn Pettis (4/2/2012)
I would be curious the value for is_broker_enabled in sys.databases for this database.
SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb';
Returns:
is_broker_enabled
1
April 2, 2012 at 3:43 pm
Lynn Pettis (4/2/2012)
Lowell (4/2/2012)
Lynn Pettis (4/2/2012)
What has me slightly confused is you talk about using Database Mail, but the code you show...
April 2, 2012 at 3:40 pm
SQLKnowItAll (4/2/2012)
Hmm... Can you post the results of sp_configure?
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Database Mail XPs' changed from...
April 2, 2012 at 3:37 pm
Viewing 15 posts - 1,561 through 1,575 (of 3,738 total)