An inconsistency was detected during an internal operation

I am getting the following error:

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database 'Finance'(ID:5) on page (1:361249). Please contact technical support. Reference number 3.

It is caused by the following simple query:

"SELECT DISTINCT GainStd FROM vPriceParamStdDiscrete WHERE GainStd IS NOT NULL ORDER BY GainStd"

Could anyone offer any tip for fixing this problem?

Thanks in advance!

hz

DIdi you try to run DBCC CHECKDB for the appropiate database ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks, Jens.

I should have done it, but I was so frustrated that I backed up the database, uninstalled and reinstalled the server (I need to do this anyway because my evaluation copy was expiring and I reinstalled a standard edition). Now, everything is fine.

hz

|||

That worked for me.

Weird. All of the sudden it started happening.

Aah!!! It is after all a Microsoft product. What else can you expect?

Thanks

Narayanan

|||When I use DBCC CHECKDB to check or repair (with REPAIR_REBUILD), I got An inconsistency was detected during an internal operation in database 'tempdb'

I can't set tempdb database as single user mode, so I can't repair it. What can I do?