What is your destination? Is there a reason why you are not using OLE DB?

Apparently there is a syntax error in your SQL query. Can you run the query on MySQL directly?

SQL 2005 and 2008 use different providers. I believe it is SQLNCLI.10 or something.

It might be worth taking a look into that.

GilaMonster (1/6/2011)

---

There's a fair bit of incorrect...

An additional resource that says table scan and index scan are not the same (as opposed of the article of Pinal Dave):

http://www.sql-server-performance.com/faq/graphical_query_pla_%20optimizer%20_p1.aspx

deepikamm (1/6/2011)

---

i want to know the exact diference between table scan and index scan.i read about 6 to 7 articles but they are all confusing..am not able to drive into...

It's best that you create a specific thread if your question is not related...

How did you configure the connection string?

What kind of admin are you?

BOL says:

You probably have set up the quarter attribute as non-repetitive.

Meaning, the quarters are actually 2011Q1, 2011Q2, 2011Q3, 2011Q4, 2012Q1, 2012Q2, 2012Q3 and 2012Q4.

So they are distinct, just not what you...

raj.lath-932078 (1/6/2011)

---

Does anyone know about some simple utility which takes backup of the / creates a copy of the mdf and ldf files to some other location that can be...

You can also configure the retry-attempts in the advanced tab of the jobstep.

cengland0 (1/6/2011)

---

Hugo Kornelis (1/6/2011)

---

cengland0 (1/6/2011)

---

Meh, I could just as well say that everything is consecutive in a single-row rowset.

According to http://www.thefreedictionary.com/consecutive, "consecutive" means (a.o.) "Following one after another without interruption"...

Nice and easy. Thanks!

vinodh247 (1/6/2011)

---

Craig,

I have not copied these q's from any site, these are the questions i was asked in the interview. I'm a newbie to this site and this is my...