I am trying to use sp_refreshview with the view 'columns' but get this error message when I run it. I am logged in as sa.
Server: Msg 229, Level 14, State 8, Procedure sp_refreshview, Line 1
DBCC permission denied on object 'COLUMNS', database 'camp', owner 'INFORMATION_SCHEMA'.
Any one have any ideas!
thanks in advance
When I execu sp_refreshview,
I got this error message on a valid view on SQL 2005 express edition.
Msg 8197, Level 16, State 8, Procedure sp_refreshview, Line 1
Object 'vName' does not exist or is invalid for this operation.
Next, I got a similar error on SQL 2005 for a valid view.
Msg 8197, Level 16, State 8, Procedure sp_refreshview, Line 1
Object 'vNamehere' does not exist or is invalid for this operation.
Is this Microsoft Bug?