Solved

suppress a result when using sql print

Posted on 2009-07-07
9
368 Views
Last Modified: 2012-05-07
I was wondering if there was a way a simple way of surpressing the server returning a :

Msg 15200, Level 16, State 1, Procedure sp_helpremotelogin, Line 14
There are no remote servers defined.

When I run the below code ?
print ''
print '<A Name="7"></A><B>7. Information about remote servers </B>'
print '*****************************************'
print ''
 
exec sp_helplinkedsrvlogin
exec sp_helpremotelogin
print '<A HREF="#TOP"><TOP></A>'
go

Open in new window

0
Comment
Question by:mooriginal
[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
  • 4
  • 4
9 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 125 total points
ID: 24799744
One workaround would be to modify the sp_helpremotelogin stored procedure and create a new one that does not trigger that error.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24849094
Can you please tell me what was wrong with the solution I supplied?
0
 

Author Comment

by:mooriginal
ID: 24849652
sure

didnt have a chance to explore your suggestion myself

and the need to answer the question moved focus from this question in particular.
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24851638
0
 

Author Comment

by:mooriginal
ID: 24852497
ok cant see what you mean from that link
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24854989
I am sorry, but my comment was directed at a Moderator in Community Support.
0
 

Author Comment

by:mooriginal
ID: 24857352
ah i see
no worries
0
 

Author Comment

by:mooriginal
ID: 24859907
i guess you get the points
i dont mind as you have been polite

otherwise id make a comment about it
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

710 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