Microsoft KB Archive/89068

= BUG: Error 225 When Using ALTER TABLE in a Batch =

Article ID: 89068

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q89068



BUG# NT: 871 (4.2)



SYMPTOMS
If the ALTER TABLE statement is used with other SQL statements in a single batch, the following error message appears:

Can not run query -- referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

(msg 225, level 16, state2)



CAUSE
The ALTER TABLE statement cannot be combined with other SQL statements in a batch.



WORKAROUND
Do not combine ALTER TABLE with other SQL statements in a single batch.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here as it becomes available.

Additional query words: Transact-SQL together Windows NT

Keywords: kbprogramming KB89068

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.