We help IT Professionals succeed at work.

suppress a result when using sql print

mooriginal
mooriginal asked
on
Medium Priority
456 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

Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2012

Commented:
Can you please tell me what was wrong with the solution I supplied?

Author

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.
CERTIFIED EXPERT
Top Expert 2012

Commented:

Author

Commented:
ok cant see what you mean from that link
CERTIFIED EXPERT
Top Expert 2012

Commented:
I am sorry, but my comment was directed at a Moderator in Community Support.

Author

Commented:
ah i see
no worries

Author

Commented:
i guess you get the points
i dont mind as you have been polite

otherwise id make a comment about it
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.