I got it to work by joining just on the left 4 charracters of the number in the subquery.

select number, avalue, (select x.nvalue from valuestbl as x where...

Yes, I have full backups from before the first error message and transcaction log backups. They have been working. The server adminstrators and our vendor say the drives are...

Results of the dbcc checkdb:

for one database:

Msg 8966, Level 16, State 2, Line 1

Unable to read and latch page (1:16648) with latch type SH. 1117(The request could not be performed...

I'll for sure have backups run before starting. Also will leave all the SQL Server services up. My only question now is how Sharepoint may effect it. ...

I have a question about the query you sent to check if the backup was running. It worked great, I could see its' progress and knowing it was actually working...

Results from the first query show the backup is 43.73% done and est finish time of 14:43, the % done has been changing.

From the second query sent in attachment called...

From sp_who2:

Status Dbname Command ...

Here's what worked:

select * from openquery (LAWSONPROD,

'SELECT

...

Yes, it is linked server to an Oracle database. And also yes, it's a new server with Oracle client and tnsnames in place. Thanks so much.

I'm sorry, I forgot to put that in! Error is:

OLE DB provider "OraOLEDB.Oracle" for linked server "LAWSONPROD" returned message "ORA-01858: a non-numeric character was found where a numeric was...

Thanks very much for the advice. The memory errors have only started since an upgrade of our SQL Server and our application about a month ago. The application has...

If it is recommended to change the max memory settng from the default, should I use 6Gb in this case then because we have 8Gb on the server?

Or because this...

Thanks, I have read that article. It lists suggestions for 64 bit, but not 32 bit.

In the discussions he also mentions that running x86/Windows 2003 will only be able...

Rebooting the server seems to have fixed it. Thanks very much.

No error messages are in the log. I saw the time out messages in the Event View system log.

A timeout (30000 milliseconds) was reached while waiting for a transaction...