Fixing Unexpected Deletions in SQL Server 2000

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.

ITPro Today

March 3, 2004

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like