开发者

How to use linked server with stored procedure?

开发者 https://www.devze.com 2023-02-24 16:23 出处:网络
Anyone have an idea about how to useto view a stored procedure on a linked server?I don\'t have the credentials to that linked serv开发者_StackOverflow社区er to look at it. ??If you don\'t have access

Anyone have an idea about how to use to view a stored procedure on a linked server? I don't have the credentials to that linked serv开发者_StackOverflow社区er to look at it. ??


If you don't have access to the server, then you can't view anything. If you have execute permissions on the stored procedure, then sure, you can execute it. I believe the syntax is something like

exec "linkName"."dbname"."schema"."procedure"  
0

精彩评论

暂无评论...
验证码 换一张
取 消