When you run a distributed query that uses a four-part name to delete or to update rows on a linked server table in a SQL Server 2000 database, the rows in the linked server table that don't satisfy the join condition are also deleted. This problem might occur if the DELETE or UPDATE statement in the distributed query involves a join and uses non-ANSI syntax. A supported hotfix is now available from Microsoft, but read the Microsoft article, "FIX: Unexpected rows are deleted when you run a distributed query to delete or to update a linked server table" before you apply the hotfix. If you aren't severely affected by this problem, Microsoft recommends that you wait for the next SQL Server 2000 service pack that contains this hotfix. Read the article at
http://support.microsoft.com/?kbid=825043
