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
Start SQL Server 2005 Management Studio.
Click New Query to open a query window, and then execute the following statement: