sp_refreshview throwing an error

Question

It can't be permission since I am the dbo. I just recompiled the view.

USE AdventureWorks2012;
GO
EXEC sp_refreshview 'Sales.vSalesByDateByProduct';
/*
Msg 15165, Level 16, State 1, Procedure sp_refreshsqlmodule_internal, Line 55
Could not find object 'Sales.vSalesByDateByProduct' or you do not have permission.
*/

SELECT object_id('Sales.vSalesByDateByProduct','V');  -- 140579589

---

Kalman Toth SQL 2008 GRAND SLAM
New Book: SQL Programming & Database Design Using Microsoft SQL Server 2012

Answer 1

Do you get the same error when you do this using dynamic SQL?

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

Same error with dynamic execution:

EXEC ('EXEC sp_refreshview ''Sales.vSalesByDateByProduct'';');

---

Kalman Toth SQL 2008 GRAND SLAM
New Book: SQL Programming & Database Design Using Microsoft SQL Server 2012

Answer 3

Please refer the below connect:

http://connect.microsoft.com/SQLServer/feedback/details/676728/sp-refreshview-crashes-with-misleading-error-on-views-with-schemabinding

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.