The query Gail had you run returns the version of SQL Server you are connected to, not the version of the client tool running the query.

Luke L (1/19/2010)

---

Lynn Pettis (1/19/2010)

---

Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under...

I think that is fallback option if the EU decides Oracle and Sun shouldn't merge. 😉

You probably have the SQL Server 2005 client tools installed on your desktop. SSMS can work with SQL Server 2000.

Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under SQL Server 2008 EE....

GilaMonster (1/19/2010)

---

Lynn Pettis (1/19/2010)

---

GilaMonster (1/19/2010)

---

Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page...

Sounds good.

You can do it for free, do it yourself instread of relying on...

My concern is the drive being powered off possibly causing data corruption.

GilaMonster (1/19/2010)

---

Lynn Pettis (1/19/2010)

---

Oh, there is a way to update the system tables in SQL Server 2005, here's how. Let us know if it works for you. No...

You have verbalized the desired output, could you show us what the final result of the query would look like? A picture is like a thousand words. Seeing...

Paul White (1/19/2010)

---

Alvin Ramard (1/19/2010)

---

Not a fast...

I get this one at home myself all the time... 😛

scott williams-465021 (1/19/2010)

---

When I run checkdb I get the same error above.

" The operating system returned error 21 (The device is not ready.) to sql server during a read at...

Following on with PaulB, was the database using FULL or BULK_LOGGED model?

If so, were you able to complete a tail-log backup?

If so, you may need to try 1) Restarting SQL...