Microsoft KB Archive/258442

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

Article ID: 258442

Article Last Modified on 9/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Keywords: kbbug kbpending KB258442

-

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

© Microsoft Corporation. All rights reserved.