SQL connection testing app

Last Post 02 Jan 2008 06:35 PM by sqladmin. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

01 Aug 2007 08:20 AM
Does anyone know of an app that will allow you to test a particular connection string to a SQL server 2005 instance?


New Member
New Member

13 Sep 2007 05:14 AM
This was not possible easily and best handled from client side. But we have now a system stored procedure "sp_testlinkedserver" in SQL Server 2005 that allows you to test linked server connection. This stored procedure takes a linked server name as parameter, tests the connectivity and returns 0 for success & 1 for failure. You can find more details about this stored procedure in the SQL Server 2005 Books Online.
New Member
New Member

02 Jan 2008 06:35 PM
would be nice if (within management studio) that there's a little info button somewhere (not in BOL), but rather
attached to the navigation tree that says something like:

"Click here for more relevant tips" thus displaying a small window next to it showing
stored procedures which my help with that particular piece.

for example. whenever you are drilling down to linked servers... and info button would be somewhere
in there.

that would be nice, and would keep us all from drowning in the BOL.

had to mention it.

Acceptable Use Policy