Have a look at this fine BOL article: http://msdn.microsoft.com/en-us/library/ms190264.aspx

Not a direct answer but a similar discussion was had here: http://www.sqlservercentral.com/Forums/Topic1262979-146-1.aspx

Been listening to some Negativland Chris?...

As with most things, "it depends". Having SSMS installed on the server is bad practice depending on your application.

That said, sp_who or sp_who2 should tell you who is connected.

You...

Nakul Vachhrajani (7/17/2012)

---

Personally, I believe that formatting and local adjustments should be performed by the application/UI layer and not the database. Dates in the database should be stored as UTC...

djackson 22568 (7/17/2012)

---

Scott D. Jacobson (7/17/2012)

---

kevin77 (7/17/2012)

---

Completely get rid of time zones and Daylight Saving Time across the entire world!!!!

So no matter where you are in the world, right now...

When you say it failed, what happened? Do you have a specific error message?

Lynn, that's not the case anymore but when it was it was also quite odd. Indiana had it's own timezone for a while. Parts of the state were...

I think...

Do you want to migrate the database to a new instance or are you upgrading the SQL 2000 instance in-place to SQL 2008?

I'm pretty sure this is the point where you'd restore from your last known good backup and move forward.

Correct me if I'm wrong, but wouldn't 40 disks in a RAID 1 give you 1/2 the capacity you stated. It's a mirror, so your array size is still...

Thank you...

Elizabeth.Block (5/21/2012)

---

Probably the best thing I did during this episode was to start a spreadsheet listing all the things I did so I could roll them back if performance got...

sqldba_newbie (5/16/2012)

My two cents, i have seen many times when DTA doesn't detect a missing index. Try to look at the execution plan and see if you can come...