Nice question Ron! I have had to deal with this once or twice before. Why you would write a view that just performs a select * from a single table...

Nice and easy. A good start to the week. Liked the other acronyms too!

Guessed right considering the typo.

I'd be a Subaru Outback. Multi-purpose, reliable, not too flashy and ready for just about anything.

I currently drive a 2010 Outback. Had a Honda Prelude before that. Also a reliable...

GSquared (3/21/2012)

---

Hugo Kornelis (3/21/2012)

---

Yes, as GSquared already shows.

However, there are (as far as...

I had only looked at the ANY and SOME syntax once before and did not see a need for them. They seem to perform exactly like the IN statement unless...

Thanks for the info on disabling validation. That solved my problem too. I was using SSIS to pull from Informix through ODBC. I too had to set the package to...

mtassin (3/20/2012)

---

Koen Verbeeck (3/20/2012)

---

According to CREATE VIEW (Transact-SQL):

Information that is stored...

Thanks for the question Chris. Learned something today!

Thanks too to Gail for the additional explanation.

Thanks for the easy question!

+1

Guessed and got it right. I've never actually used cache connection managers in SSIS but I may have to look into it. Bring on more SSIS questions! 🙂

Thanks for the question Steve! Had to look this one up. I agree with others, Authorization is a little misleading in this context.

Thanks for the question Ron. Learned something today!

We still run a number of systems off 2000 but are in the process of migrating most to newer versions. The challenge for us has been timing and licensing. There...