This topic has not yet been rated - Rate this topic

sp_testlinkedserver (Transact-SQL)

Tests the connection to a linked server. If the test is unsuccessful the procedure raises an exception with the reason of the failure.

Copy


          

sp_testlinkedserver [ @servername ] = servername

[ @servername = ]servername: Is the name of the linked server. servername is sysname, with no default value.

None

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

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

sp_addlinkedserver (Transact-SQL)

sp_addlinkedsrvlogin (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ