DB-Library Process Dead

[Ali Alhussein]

hi, I ran a query on a test database and got this error , does anyone tell me whatdoes it mean and how can I fix it

thanks
Ali
This command did not return data, and it did not return any rows

DB-Library Process Dead - Connection Brokenh

[Greg]

that means, SQL Server didn't like your query.
I'd use :
set showplan on
go
set noexec on
go
<your query>
set noexec off
go
set showplan off
go

and check all step, watch for indexes optimizer is trying to use, then check that indexes...

On 2/16/99 3:48:15 PM, Ali Alhussein wrote:
> hi, I ran a query on a test database and got this error , does anyone tell
> me whatdoes it mean and how can I fix it

thanks
Ali
This command did
> not return data, and it did not return any rows

DB-Library Process Dead
> - Connection Brokenh