Koen Verbeeck (12/7/2011)

---

:w00t: Easy one! Thanks!

It should be easy to test.

WITH CTE_Numbers (number)

AS

(SELECT ROW_NUMBER() OVER (ORDER BY sc1.name) AS number

FROM master.sys.columns sc1, master.sys.columns sc2)

SELECT TOP 32767 'CREATE DATABASE...

This looks like permissions problem.

Please make sure that the SQLS Engine has access rights to the respective directory.

BTW, typically SQLS jobs are deployed into a separate directory, not into Program...

The former one is the MSDN download version, the latter one the Windows Update version, but I can only guess that they are different builds.

Yes, that is a good start.

If you run into a problem, I am here.

Foreign?

bitbucket, you are thereby appointed an SQLServerCentral sneak in residence. 🙂

Thanks for an interesting QotD!

Virtualization is the way to go.

Jeff Moden (12/6/2011)

---

To be honest, I didn't enter... didn't even try to answer a single question. They wanted a "tweet" from outer space and I refuse to sign up....

Could you please quote someone who reconciled the concept of the Common...

Steve Jones - SSC Editor (12/6/2011)

---

Tony Palmeri (12/6/2011)

---

sqlnyc (12/6/2011)

---

Everyone has a right to complain, whenever and about whatever they want - that's the very essence of free speech. Your opinion...

Yes, it can and should.

I believe there are no specific instructions. Windows Update should do it for you.

I forgot to mention that before you build your project for deployment, you ought to make sure that you build a Release version. (Not Debug.)

You do not run your VB project - you need a Deployment Project that will reference primary output of your VB project. (There are walkthroughs for that.)

Then you buld...

Wow - one of the best questions is a long time... Thank you, Hugo!

Michael Valentine Jones (12/5/2011)

---

Michael Valentine Jones (12/3/2011)

---

The worst abuse is when they set short project deadlines without any attempt to match the workload to the available staff, and then expect...