SyntaxFix

[sql] SQL using sp_HelpText to view a stored procedure on a linked server

Anyone have an idea about how to use sp_helptext to view a stored procedure on a linked server? basically something like this. I don't have the credentials to that linked server to look at it. 

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

thanks ahead.

This question is related to sql sql-server tsql

The answer is

Instead of invoking the sp_helptext locally with a remote argument, invoke it remotely with a local argument:

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

It's the correct way to access linked DB:

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

But make sure to mention dbo as it owns the sp_helptext.

Little addition in answer if you have different user rather then dbo then do like this.

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

sp_helptext [dbname.spname] try this

Source: Stackoverflow.com

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to tsql

• Passing multiple values for same variable in stored procedure • Count the Number of Tables in a SQL Server Database • Change Date Format(DD/MM/YYYY) in SQL SELECT Statement • Stored procedure with default parameters • Format number as percent in MS SQL Server • EXEC sp_executesql with multiple parameters • SQL Server after update trigger • How to compare datetime with only date in SQL Server • Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot • Printing integer variable and string on same line in SQL

Tags

Reverseprojection Dice Quicklaunch Blacklight Ultrasphinx Sqlanywhere Partial-trust Selenium-grid Solution Volatile Monkeypatching Fuzzyfinder Getdirectories Webproject Xsltc Ksh Apng Function-parameter Reflector Soundpool Field-names Sourcegear-vault Spectrogram Phpquery Edirectory Avcapturedevice Skunk-works Formatmessage Scrollrect Mem-fun Bnf Asp.net-3.5 Css-selectors Gpc Pixel-shading Nopcommerce Xpc Signer Operating-system Jpa Datetimeoffset Interruptions Double-pointer Rshd Big-ip Onupdate Riff Ref-parameters Mercurial Periodformatter Osgi-fragment Elpa Mbstring Routevalues Reverse-engineering Browser Ubuntu-server Nswindow Gridex Mkmapview Authorize.net Rfc2231 Keyevent Hcluster Gnucobol Qlistwidget Garmin Quartz-composer Nbehave Watchdog Gateway Nfs Checkbox Rd Affiliate Document-body Hibernate-session Recurring Project-planning Nolock Movefileex Linksys Php-include Undo-redo Tramp Innertext Jeditorpane Circuit Prediction Createobject Routedata Non-printable Redis Rpm-spec Advapi32 Mediacontroller Plc Nonclient Sign Videochat