Home Library Learn Samples Downloads Support Community Forums
0 out of 2 rated this helpful - Rate this topic

sp_testlinkedserver (Transact-SQL)

SQL Server 2005

Updated: 14 April 2006

Tests the connection to a linked server.

Topic link icon Transact-SQL Syntax Conventions

Copy 

sp_testlinkedserver [ @servername ] = servername
[ @servername = ] servername

Is the name of the linked server. servername is sysname, with no default value.

No permissions are checked; however, the caller must have the appropriate login mapping.

0 (success) or 1 (failure)

The following example creates a linked server named SEATTLESales, and then tests the connection.

Copy 
USE master;
GO
EXEC sp_addlinkedserver 
    'SEATTLESales',
    N'SQL Server';
GO
sp_testlinkedserver SEATTLESales;
GO

Release History

14 April 2006

New content:
  • Added the Examples section.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.