CODEWITHSUNDEEP
sql-serverstored-procedureslinked-server
Eliseo Jr
Eliseo Jr

Reputation: 141

How to view the SQL Server stored procedure from linked server?

Anyone has the idea how to get this through?

I have a production and a test server. I created a linked server of production on the test server machine. I can do all DML that affects the production server from the test server, but I cannot see the stored procedure object of the production server on the test server.

RPC and RPC Out is already True.

Upvotes: 2

Views: 3725

Answers (1)

Darshak
Darshak

Reputation: 867

I hope this will help you. Using sp_HelpText you get entire SP text.

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

Upvotes: 2

Related Questions