Sql-server – Source code of View of Linked server sp_HelpText

linked-serversource codesql server

How to use sp_helptext for view on the linked server ?

Best Answer

There is an answer on SO: SQL using sp_HelpText to view a stored procedure on a linked server

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

Related Solutions

Sql-server – Sp_helptext Error

Maybe try:

EXEC Foo..sp_helptext 'dbo.[Test.FooBar]';

Still having problems with sp_helptext? Ok, stop using it - it's not the only way to get the object's definition.

SELECT OBJECT_DEFINITION(OBJECT_ID('dbo.[Test.FooBar]'));

Next, please stop putting . and other special characters within object names.

Sql-server – Connecting Linked Server

Dynamic SQL:

declare @ServIP varchar(50) = 'IP of server'
declare @dsql varchar(1024)
set @dsql = 'select * from ' + quotename(@ServIP) + '.DbName.dbo.TableName'
exec (@dsql)

Best Answer

Related Solutions

Sql-server – Sp_helptext Error

Sql-server – Connecting Linked Server

Related Question