Viewing 15 posts - 2,536 through 2,550 (of 11,676 total)
Evil Kraig F (6/18/2014)
Grant Fritchey (6/18/2014)
Yeah, one guy offered to pay me, so I sent him my rate. And that was the end of that.
Heh, I don't mark up when...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 19, 2014 at 12:07 am
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 19, 2014 at 12:04 am
Nice question, thanks Andy!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 19, 2014 at 12:01 am
An alternative is to run all the packages and use SQL profiler to monitor which packages make connection to the configuration table.
You know, why keep things simple? 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 11:57 pm
Chitown (6/18/2014)
Thank you:-). I am assuming this is all I need other than setting up DB mail and SQL job to run this procedure.
I think that's about it yes 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 2:36 pm
You start with a simple count.
DECLARE @CountRows INT;
SELECT @CountRows = COUNT(1)
FROM myTable
WHERE Name = 'Jim';
Then you compare the count against a certain condition. If true, send an email.
IF @CountRows >...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 2:22 pm
Sean Lange (6/18/2014)
Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of something and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 2:07 pm
Grant Fritchey (6/18/2014)
SQLRNNR (6/18/2014)
jasona.work (6/18/2014)
GilaMonster (6/17/2014)
"No pressure to work overtime"...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 2:03 pm
gbritton1 (6/18/2014)
Koen Verbeeck (6/18/2014)
The answer is incorrect.The question clearly states that the databases are on site. Thus, by the process of elimination, the corruption answer is the only one left.
Wrong!...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 1:54 pm
Ryan1 (6/18/2014)
This works you are the man! Thank you so much.Any chance I can make this thing smaller?
Glad you got it resolved.
What do you want to make smaller?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 1:32 pm
danielfountain (6/18/2014)
Badly worded, but you cant say that they said the databases are all on site and 2012 - because they didnt say that!
Maybe they use SQL 2000 for their...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 7:30 am
How did you configure the OLE DB destination?
Anything special?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 7:15 am
Any other errors in SSIS?
If you hardcode the value for @WorkingAttributeTableName, does it work?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 7:10 am
jasona.work (6/18/2014)
The Index rebuilds. They're around 1/2 (maybe a bit more) of the total time for the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 6:58 am
A bit is a boolean, so I'm not sure what you are getting at.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2014 at 6:51 am
Viewing 15 posts - 2,536 through 2,550 (of 11,676 total)