Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

suppress a result when using sql print

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
mooriginal
Asked:
mooriginal
  • 4
  • 4
1 Solution
 
Anthony PerkinsCommented:
One workaround would be to modify the sp_helpremotelogin stored procedure and create a new one that does not trigger that error.
0
 
Anthony PerkinsCommented:
Can you please tell me what was wrong with the solution I supplied?
0
 
mooriginalAuthor Commented:
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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Anthony PerkinsCommented:
0
 
mooriginalAuthor Commented:
ok cant see what you mean from that link
0
 
Anthony PerkinsCommented:
I am sorry, but my comment was directed at a Moderator in Community Support.
0
 
mooriginalAuthor Commented:
ah i see
no worries
0
 
mooriginalAuthor Commented:
i guess you get the points
i dont mind as you have been polite

otherwise id make a comment about it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now