Great question and a nice way to end the week. 🙂

Correct answers: 2% (3)

Incorrect answers: 98% (162)

Total attempts: 165

We are the 98%. :ermm: So much for some easy points 2 days in...

I'm not sure if this is what you're looking for, but here are a couple of articles that might be of some assistance.

http://www.databasejournal.com/features/mssql/article.php/3491201

http://www.databasejournal.com/features/mssql/article.php/3500276/Identifying-Long-Running-SQL-Server-Agent-Jobs.htm

Excellent question. Thank you for that and Duncan thank you for that entertaining read. Poor guy, I kinda felt sorry for him at the end. I guess this is just...

Great easy question this morning Steve. Thanks for that pick me up on Monday. 🙂

Great question. Finally redeemed myself after missing a couple this week. Great way to start a Friday morning. 😀

I jumped the gun on this one and it seems I'm not alone in my actions. I just saw the first answer and was like "of course that's what you...

Hugo Kornelis (6/22/2012)

---

codebyo (6/22/2012)

---

Thanks for the question and thanks to Hugo for the detailed explanation.

This could be a useful code to set some fields from a a few restricted rows...

Excellent question Koen. I can always count on you to come up with some great SSIS questions to get the day started right. 😀

I'm agreeing with what most people have put up before myself. Great question, it really made me think, but the answer format played some tricks on my brain this early...

+1:w00t: Great question, thank you!

Great question! I ended up going with what I thought the best answer was and got it right.

I'm with a couple of the guys here and I actually had to dig down into the think tank a little to remember it. I'd never write anything (or at...

Great question, thanks! I'm with Gazareth on this one; it was just process of elimination for me.

+ 1 😀

Glad to see some more SSIS QotD's floating around there. Great job as...