I need to execute `sp_refreshview` on the other database by using the created linked server.

For example, I have linked server `Demo_LinkedServer`. In the `AdventureWorks` database, I have created a table `Demo_TBL` and on top of the table, created a view named `VW_Demo_TBL`.

Now, I am in a database `Demo_Database`. How I could execute `sp_refreshview` in `AdventureWorks` by using linked server `Demo_LinkedServer`?

First attempt:

```
exec Demo_LinkedServer.AdventureWorks.dbo.sp_refreshview N'dbo.VW_Demo_TBL'. 

```

I get the error:

> 
> Server 'Demo\_LinkedServer' is not configured for RPC.
> 
> 
> 

Second attempt:

```
SELECT * 
FROM OPENQUERY(Demo_LinkedServer, 
               'EXEC sp_refreshview N''dbo.VW_Demo_TBL''')

```

Now I get this error:

> 
> Msg 11528, Level 16, State 1, Procedure sys.sp\_describe\_first\_result\_set, Line 1 [Batch Start Line 118]  
> 
> The metadata could not be determined because statement 'EXEC %%TriggerEx(MultiName = @name).LockMatchID(ID = @objid, Exclusive = 1, NameSpaceClass = @ns)' in procedure 'sp\_refreshsqlmodule\_internal' does not support metadata discovery.
> 
> 
>