|
Home > Archive > MS SQL Server > February 2006 > internal server error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
internal server error
|
|
| Dan Holmes 2006-02-10, 11:23 am |
| Ideas on this one?
SQL Server 2000
Msg 8624, Level 16, State 8, Line 1
Internal SQL Server error.
this is the offending SQL
select distinct orlc.orderid, orlc.releaseid, 'BBI', 'AUTO',
(select count(distinct orderid)
from InventoryDetail id1
inner join orderreleaselinechil
d orlc1 on (orlc1.containerid =
id1.containerid and orlc1.lineid = (select min(lineid) from
orderreleaseline where orderid = orlc1.orderid and productid =
id1.productid))
where invflag = 'I' and stage = 'P' and status = 'S'
and exists (select * from taurus.data_01.dbo.oehdrhst_sql where ord_no
=orlc1.orderid)
and orlc1.orderid < orlc.orderid)
, 'MAN-DOCK' from InventoryDetail id
inner join orderreleaselinechil
d orlc on (orlc.containerid =
id.containerid and orlc.lineid = (select lineid from orderreleaseline
where orderid = orlc.orderid and productid = id.productid))
where invflag = 'I' and stage = 'P' and status = 'S'
and exists (select * from taurus.data_01.dbo.oehdrhst_sql where ord_no
=orlc.orderid)
| |
| Razvan Socol 2006-02-10, 1:23 pm |
| Hello, Dan
What version of SQL Server 2000 are you using ?
Please post DDL for all the tables involved in the query (including
indexes), so we can attempt to reproduce the problem.
Does the problem happen if you use a "oehdrhst_sql" table in the
current database instead of using the linked server ?
Razvan
| |
| Dan Holmes 2006-02-10, 8:23 pm |
| Razvan Socol wrote:
> Hello, Dan
>
> What version of SQL Server 2000 are you using ?
8.0.194. That is SP1. I am upgrading to Sp4 to see if it changes.
>
> Please post DDL for all the tables involved in the query (including
> indexes), so we can attempt to reproduce the problem.
working on that. inventorydetail is a view of many tables.
>
> Does the problem happen if you use a "oehdrhst_sql" table in the
> current database instead of using the linked server ?
yes
>
> Razvan
>
dan
|
|
|
|
|