Solved

suppress a result when using sql print

Posted on 2009-07-07
9
365 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
  • 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

821 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