sql 2000 sp4

What would cause this type of timeout?


DB1 - Table Members indexed memberid -
view1 contains data referencing TABLE ABOVE including memberid
table count 1.5m +/-
DB2 - Table Members indexed memberid -
view2 contains data referencing TABLE ABOVE including memberid
table count 4.5m +/-

DB3 - combinView contains
select *
from view 1
union all
select *
from view2

When accessing view through DB3
select *
from combinView
where memberid = 'xxxxxx'


Receiving time out error

however when I query the views separately they execute in less than a second.
The only change that I've made is drop the table in db1 and recreated it along with the indexes. I've refreshed the view/deleted and recreated all three. Rebuild the indexes.

Do you see any errors logged into SQL server Error log?

See if this fixes your problem.

FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file

_________________________
- Vijay G
Strive for Perfection