BUG: Error 225 When Using ALTER TABLE in a Batch

ID: Q89068

The information in this article applies to:

BUG# OS/2: 1375 (4.2)
       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 SQL Server version 4.2 for OS/2 and Microsoft SQL Server versions 4.21 and 4.21a. We are researching this problem and will post new information here as it becomes available.

Additional query words: Transact-SQL together Windows NT 


Keywords          : kbprg kbbug4.20 SSrvServer SSrvWinNT 
Version           : 4.2 | 4.21 4.21a
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 16, 1999