Solved

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

Posted on 2011-09-16
2
1,066 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
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can I get blanks instead of zero's to show up in my results? 2 30
Syntax using Declare 4 38
sql query help 4 45
SQL compatability in SQL 2016 2 32
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…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

895 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now