BUG: Sp_refreshview Does Not Pick Up Changes When a Column is Dropped in the Base Table (258442)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q258442
BUG #: 57773 (SQLBUG_70)

SYMPTOMS

Sp_refreshview does not pick up changes when a column is dropped from the base table. Instead, this error occurs:
Server: Msg 4502, Level 16, State 1, Procedure myview, Line 1
View 'myview' has more column names specified than columns defined.
Server: Msg 4413, Level 16, State 1, Line 1
Could not use view 'myview' because of previous binding errors.
The problem does not occur when you add a column to the base table.

WORKAROUND

You can drop and recreate the view. You can also use the ALTER VIEW T-SQL command, which will alter a previously created view without affecting dependent stored procedures or triggers and without changing permissions.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Modification Type:MajorLast Reviewed:9/4/2002
Keywords:kbbug KB258442
©2002 Microsoft Corporation. All rights reserved.