Change the properties in the model database, then create the 20 databases simply using the CREATE DATABASE statement.

Every new database is created from a copy of the model database.

Don't forget...

Definitely yes. Cursors are not as bad as they may seem, just make sure you're using them in the right way.

The one used in sp_MsForEachTable is declared GLOBAL, but...

Not trying to be picky, but sp_MsForEachTable uses a cursor internally.

GilaMonster (2/29/2012)

---

Gianluca Sartori (2/29/2012)

---

GilaMonster (2/29/2012)

---

The marketing launch event is in a couple of days. Availability of the bits, probably not...

End of...

Oh my!

This is hlarious! I had never noticed it before:

Koen Verbeeck (2/29/2012)

---

Gianluca Sartori (2/29/2012)

---

I partially agree. Sometimes head meets wall years after the discussion and there's not much left to do at that point.

Saying "I told you so"...

SQL Server 2012 will be out in some days.

The latest version to date is SQL Server 2008 R2.

I suppose the values 3 and 4 should be associated with 'HOSTNAME3' rather than 'HOSTNAME2'.

This is how I would do it:

SELECT *

FROM Delivery AS DLV

WHERE EXISTS (

...

Koen Verbeeck (2/29/2012)

---

Gianluca Sartori (2/29/2012)

---

Revenant (2/28/2012)

---

Gianluca Sartori (2/28/2012)

---

What??? You mean less people!

What...

Tempdb probably blows because of excessive parallelism. I've seen this happening quite often.

This means you should review your indexes, because the optimizer most likely chooses to ignore some of those...

Revenant (2/28/2012)

---

Gianluca Sartori (2/28/2012)

---

What??? You mean less people!

What would I do for...

Moving logic in CLR or application won't protect the code, that can always be disassembled and reverse-engineered.

Personally, I would try to avoid the "security by obscurity" approach and I would...

What??? You mean less people!

What would I do for a living with...

varchar would be a better choice. I highly doubt you will ever need to store unicode...