Wahoo! Got it right! I have to admit that I wasn't sure about the last three options, but I figured that since they were there, at least one...

Wow. I didn't believe that the error message was coming from the client - I still figured it was one of the settings being missed somewhere, but I ran...

This was quite a surprise to me. I would have expected the Date and Datetime to have worked the same way, but I guess that's why I come back...

I don't think I...

That's good to know. I wondered when it would be there, but didn't see anything obvious.

Chad

Woohoo. SQL 2008 R2 RTM'ed this morning (or evening depending on your timezone preference)

2008 RTM - SQL Server Team Blog

Chad

TempDB is created from model right? So if you were able to set the model to read only and it actually carried through, what would happen when you restarted...

Great suggestion Steve! I'll see if someone in our local users group has a copy I can borrow.

Thanks,

Chad

Awesome. Thanks Jason!

This is totally off topic, but being...

Jason Shadonix (4/12/2010)

---

Lynn Pettis (4/12/2010)

---

CirquedeSQLeil (4/12/2010)

---

Where is that one?...

You know why they called it Golf right? All the other 4-letter words were taken.

Chad

Paul White NZ (4/3/2010)

---

SQL Server 2008 compression has taken away my reasons for using a third-party tool anyway - and apparently R2 extends backup compression to Standard Edition, which is...

Ah. I missed that. I was thinking of setting up the Snapshot to run once per week, and then maintaining that publication as procs or tables were updated....

TheSQLGuru (4/2/2010)

---

2) script and drop ALL indexes if you are deleting 85% of the data. Do the deletes, shrink database, grow data file back out manually, create indexes. ...