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...

Ramji29 (1/19/2010)

---

try this.

USE master

EXEC sp_configure 'show advanced option', '1'

go

RECONFIGURE WITH OVERRIDE

go

EXEC sp_configure 'allow updates', '1'

go

RECONFIGURE WITH OVERRIDE

go

--Now update the table u wanna update

begin tran

update master.sys.sysdatabases set status = 16 where...

Stupidity

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 warning about NOT...

Best suggestion, tail-log backup, then restore the database.

I have to question updating the system tables to begin with. This isn't something that should be done without a lot of thought and testing. The fact that...

It would help to see all the code, not just a snippet. Based on the snippet alone, hard to say as there are variables being used in the INSERT...

First, and most importantly, do you have current backups? Was the log file on the same drive? If not, you may want to do a tail log backup....

Who decides what is right (or better, when it is right), the developer or the client/stakeholder/user?

How many XML indexes can you have on a table with no XML columns?

To be honest, when asked about number of indexes, unless specifically asked about FTI and XML indexes,...

No, you cannot update system tables.

I can't really figure out what you want. Please take your sample data and show me what the correct output would be. Also, include any additional info based...

amitabhssinha (1/19/2010)

---

Hi There All,

I have a table with DateTime field with millions of record. Now I want to retrieve records based on search criteria of DateTime field.

I have...