Thanks to everyone who responded to this topic.

Reddy,

You got it right. Our IT Team did some changes to our storage server which resulted in some of the data files being...

Steve,

Thanks for the reply.

But when i tried to reset its status using sp_resetstatus I got the following message:

No row in sysdatabases was updated because mode and status are already correctly...

El,

Try this:

sp_msforeachdb 'Use [?] Select * From sysfiles'

HTH,

Ravinder

Joe,

Try this:

SELECT  f1,f2,f3 

  CASE

   WHEN f1 = 'K' THEN

    -1*(view_v.f2)

   WHEN f1 = 'D' THEN

    -1*(view_v.f2)

  END 'glamount'  

 FROM view_v

 WHERE f3 = 'somevalue'

It will convert negatives to positives and vice versa as desired.

HTH,

Ravinder

Joe,

Try this:

http://objectsharp.com/Blogs/matt/archive/2005/06/13/2221.aspx

HTH,

Ravinder

"Snapshot too old" is not a SQL related error message. It is something related to Oracle.

Go to http://asktom.oracle.com and type in your string to get the details.

Regards