To be honest it probably depends when the application was written and for what version of SQL Server.

I have found that alot of 3rd party application developers have been lazy...

Marvin,

Go to "Add/Remove Programs" and uninstall the Microsoft SQL Server Native Client.

Chris.

I have now managed to fix this issue. This problem was fixed with SQL Server 2005 Express Edition with Advanced Services SP2.

http://go.microsoft.com/fwlink/?linkid=65109

When was the last time you reindexed or updated the statistics on these tabels?

Also, have you tried running this as native SQL code and not in a stored procedure? I...

How many rows are in the tables? Don't forget that Cursors operate row by row and are therefore slow.

Are you using cached reports?

Go to "stored procedures [SQL Server], categories" in SQL Server 2005 BOL.

I presume you ware trying to get your merge subscription working on XP Professional and not Vista?

Please can you post the exact error message you are getting.

Is the database in full recovery mode?

Have you got database and transaction log backups?

If so you could restore them to antoher database and then extract the rows out that you...