SQL using sp_HelpText to view a stored procedure on a linked server

Question

How can I use sp_helptext to display a stored procedure on a linked server? Essentially something like the following.

I am not having the credentials to that linked server to look at it.

EXEC sp_HelpText '[ServerName].[DatabaseName].dbo.storedProcName'

Answer 1

Rather than invoking the 'sp_helptext' locally using the remote argument, you can invoke it remotely using the local argument:

EXEC  [ServerName].[DatabaseName].dbo.sp_HelpText 'storedProcName'

 Join the SQL Training course now if you want to gain more knowledge in SQL.