May 20, 2014 at 4:59 am
Hi All,
Can i refresh view through linked server? I have full rights to modify the view?
Ex:ABC.MNC_DB.dbo.sp_refreshview 'view_ABC'
May 20, 2014 at 1:14 pm
My guess would be that it depends on the way security is setup for the linked server. Is the linked server passing through your credentials or is it using a sql server login for everyone?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 23, 2014 at 7:06 am
balu.arunkumar (5/20/2014)
Hi All,Can i refresh view through linked server? I have full rights to modify the view?
Ex:ABC.MNC_DB.dbo.sp_refreshview 'view_ABC'
Assuming the linked server is set up with the appropriate options & permissions, then yes, you can refresh views via linked server using a statement like:
EXEC [linkedserver].database.sys.sp_refreshview @viewname = N'your_view'
In addition to the permissions your user has, also verify that the Server Options for the linked server allow for whatever SQL you are running on the target server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply