Very Computer

Hi!!
I have been been using a table that sometimes looks like it is damaged.
When I delete and create it again, I still have problems. SQL Server 6.5
(Service Pack 2) seems to be having problems with the folowing table for
some reason that I don't understand. Could some of you try this query (in
older versions of SQL Server too) to see if it runs?

create table test (
        c1 text NULL ,
        c2 varchar(250) NULL ,
        c3 char(40) NULL ,
        c4 char(40) NULL ,
        c5 char(70) NULL ,
        c6 char(40) NULL ,
        c7 char(70) NULL ,
        c8 text NULL ,
        c9 char(30) NULL
)
go

insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')

go

update test set c9='Test'

At this point, the client connection should crash if a message like this:

Msg 806, Level 21, State 1
Could not find virtual page for logical page 538976288  in database
'traduc'
The SQL Server is terminating this process.

--
Mario De Sousa Barrera
Eniac, C.A.
Caracas, Venezuela

I tried it on SQL 6.5 SP1 and it did not produce an error.

Mario,

Sure looks like a bug to me. I wonder if it has to do with your column
names. Put the text columns at the end of the table. Then the error
shoult disappear.

Ron

On Fri, 07 Feb 1997 11:35:19 -0800, "Mario De Sousa Barrera"

Quote:>I have been been using a table that sometimes looks like it is damaged.
>When I delete and create it again, I still have problems. SQL Server 6.5
>(Service Pack 2) seems to be having problems with the folowing table for

>[text deleted]

>Msg 806, Level 21, State 1
>Could not find virtual page for logical page 538976288  in database
>'traduc'
>The SQL Server is terminating this process.

 ________   Lance Andrewes MCSE

This is a known bug in SP2.  If you complain to MS they should give you the
HotFix.  The problem is the column that follows the TEXT column.  You place
the  TEXT column at the end and it will fix the problem.  Hope this helps.

The original query seems to have scrolled off the newsgroup.  I am
experiencing SQL Server crashes too when certain queries are run.
Any chance of reposting the killer query?

Cecil Jones <cjones.healthcc.com> wrote in article

Quote:> This is a known bug in SP2.  If you complain to MS they should give you
the
> HotFix.  The problem is the column that follows the TEXT column.  You
place
> the  TEXT column at the end and it will fix the problem.  Hope this
helps.

Ken,

This is the query from the start of the post :-

create table test (
 c1 text NULL ,
 c2 varchar(250) NULL ,
 c3 char(40) NULL ,
 c4 char(40) NULL ,
 c5 char(70) NULL ,
 c6 char(40) NULL ,
 c7 char(70) NULL ,
 c8 text NULL ,
 c9 char(30) NULL
)
go

insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')
insert into test (c1) values ('Test')

go

update test set c9='Test'

At this point, the client connection should crash if a message like this:

Msg 806, Level 21, State 1
Could not find virtual page for logical page 538976288  in database
'traduc'
The SQL Server is terminating this process.

 Protech Computing Ltd (MS Solution Provider)
 Using Virtual Access 3.52 build 159c (32-bit) on NT 4.0 SP2