BUG: Error 225 When Using ALTER TABLE in a Batch (89068)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q89068 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.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbProgramming KB89068 |
|---|
|