It is not a partitioned view

RecID is from a single source table

The source table's column definition is a bigint.

Where else would it get the number from if not from a...

Totally sure.

The snippet I put in there, is where I am getting the error.

I realize it makes no sense, but that's where it's failing.

Bill

Just tried dropping and recreating the view - same issue

Bill

Casting RecID as bigint does not keep it from failing.

and the RecID column is definately a bigint.

Bill

They are both int columns

Bill

declare @test-2 bigint

select @test-2 = MAX(RecID)

FROM DBO.DATAVWOBJACCESSINFO

WHERE DATETIMEX <= '9/2/2008 10:45:03 AM' AND HANDLEID = 2964 AND ID = 567

select @test-2

This fails...

An executive decision has been made to just discard the database, rather than to recover it.

Yes, I did stop & restart the database.

I will check those links.

Thanks,

Bill

I suspect it happened when the server lost power.

It is a database we are using for stress testing purposes, so there is no backup.

When I came in & checked the...

The error causing it to be marked suspect was:

File 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\xxx.mdf' appears to have been truncated by the operating system. Expected size is 21343424 KB but actual...

I just tried that and got the error "Database 'xxx' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information."

According to BOL it is the Operating System Maximum

The question did not mention SQL 2005.

My answer was for SQL 2000.

Oh well.

There is very little load on either server, as it is an early testing situation. I'm thinking hardware as well. Whatever it is, it sure isn't making much sense.

Thanks!

Bill

This is a background process, running continuously

The same line of code is calling various stored procedures.

Sometimes the stored procedure takes 1-2 minutes, sometimes less but

at random times the line of...