I am running SQL 7.00.623 and when I am running this query
select
ACCOUNT.ACC_ID,
meeting.CREATOR_ID,
meeting.EU_ID,
meeting.ACT_AUTHBYID
from
ACCOUNT,
ACTIVITY meeting_contact,
ACTIVITY meeting
where
ACCOUNT.ACC_ID = meeting_contact.ACC_ID and
meeting_contact.ACT_TYPE = 409 and
meeting_contact.MEETING_ID = meeting.ACT_ID
I get the following error after it displays 2779 rows of data
"Server: Msg 21, Level 20, State 1, Line 1
Warning: Fatal error 1203 occurred at Mar 30 2006 11:51AM
Connection Broken"
I have tried creating a new db and restoring the data into it and removing all the indexes from the activity table and reapplying them.
Can anyone help with any suggestions?
Thank you in advance
select
ACCOUNT.ACC_ID,
meeting.CREATOR_ID,
meeting.EU_ID,
meeting.ACT_AUTHBYID
from
ACCOUNT,
ACTIVITY meeting_contact,
ACTIVITY meeting
where
ACCOUNT.ACC_ID = meeting_contact.ACC_ID and
meeting_contact.ACT_TYPE = 409 and
meeting_contact.MEETING_ID = meeting.ACT_ID
I get the following error after it displays 2779 rows of data
"Server: Msg 21, Level 20, State 1, Line 1
Warning: Fatal error 1203 occurred at Mar 30 2006 11:51AM
Connection Broken"
I have tried creating a new db and restoring the data into it and removing all the indexes from the activity table and reapplying them.
Can anyone help with any suggestions?
Thank you in advance