Solved

sp_helptext does not allow : sp_helptext OtherDB.dbo.spSelT - SQL Server

Posted on 2011-09-16
2
1,105 Views
Last Modified: 2012-05-12
Hi,

I have my stored procedure "spSelT" in "OtherDB" database. And now i cannot able to write:

sp_helptext OtherDB.dbo.spSelT

Is there any way that i can wite like above ? Modify the above command if needed.

And if i want to do for other than "dbo" schema then how to write it ?

sp_helptext dbo.spSelTest  // returns error

Please provide the command for that also.

Thanks
0
Comment
Question by:milani_lucie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 21

Expert Comment

by:JestersGrind
ID: 36551679
Try putting your database and schema before sp_helptext like this.

EXECUTE OtherDB.dbo.sp_helptext 'spSelT'

Greg

0
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 36551692
Also to answer your second question, put the object inside single quotes.

Greg

0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question