Article ID: 953119 - View products that this article applies to.
In Microsoft SQL Server 2005, you have an UPDATE statement that uses an INNER JOIN clause. When you execute the statement in the SQL pane of SQL Server Management Studio, a CROSS JOIN clause is automatically inserted into the UPDATE statement.
To work around this problem, execute the statement in a query window in SQL Server Management Studio.
To open a query window, click New Query in SQL Server Management Studio.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the problem
Article ID: 953119 - Last Review: May 27, 2008 - Revision: 1.1