My SQL 2000 and Goldmine 6.0 Locks up continually.
(Product = Corporate Edition with GoldSync® , Versions = GoldMine 6.00.30203, BDE 500 [4/11/1999], Windows NT 5.00.2195 Service Pack 3
SQL Server = Microsoft SQL Server 2000 - 8.00.760 (Intel X86))
When using the Activity List - either sorting a column or completing an activity users experience a complete deadlock. I can free it by Killing the Process using SQL Enterprise Manager but is there a permenant solution?
The command which is WAITING is always the same (with different Userid) -
set rowcount 500 SELECT * FROM dbo.CAL WHERE RECTYPE = 'C' AND USERID = 'PNICHOLL' AND ONDATE = '04/08/2003' ORDER BY REF ASC set rowcount 0
(Product = Corporate Edition with GoldSync® , Versions = GoldMine 6.00.30203, BDE 500 [4/11/1999], Windows NT 5.00.2195 Service Pack 3
SQL Server = Microsoft SQL Server 2000 - 8.00.760 (Intel X86))
When using the Activity List - either sorting a column or completing an activity users experience a complete deadlock. I can free it by Killing the Process using SQL Enterprise Manager but is there a permenant solution?
The command which is WAITING is always the same (with different Userid) -
set rowcount 500 SELECT * FROM dbo.CAL WHERE RECTYPE = 'C' AND USERID = 'PNICHOLL' AND ONDATE = '04/08/2003' ORDER BY REF ASC set rowcount 0