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"
精彩评论