Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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