[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • 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
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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