refreshing linked server from a stored procedure

refreshing linked server from a stored procedure

 

  

Hi All,

Is there a way to refresh linked server within a script or stored procedure?
I noticed unless I manually refresh the linked server in Enterprise Console,
the newly created object is not seen.

Thank you in advance.

Sang Nahm
MS Sql Server LazyDBA home page