SDP 7.0.0 Build 7018 crashing with SQL Server 2005
Hi,
I'm experimenting a serious issue with SDP 7.0.0 Build 7018 and SQL Server 2005, from time to time SDP queries are going into suspended mode in the SQL Server and then the SDP server is no more functional.
The actual workaround is to stop the SDP service, restart it and kill all blocking process on SQL Server, is there any other way to fix this?
Regards,
Patrick.
I'm experimenting a serious issue with SDP 7.0.0 Build 7018 and SQL Server 2005, from time to time SDP queries are going into suspended mode in the SQL Server and then the SDP server is no more functional.
The actual workaround is to stop the SDP service, restart it and kill all blocking process on SQL Server, is there any other way to fix this?
Regards,
Patrick.