How to find linked server table structure using T-SQL – SQL Server

The following sp_columns_ex stored procedure used to return the linked server table structure details.

EXEC sp_columns_ex ‘linkedserver_Name’, ‘table_name’, ‘Schema_name’
EXEC sp_columns_ex ‘prod_lnk’, ’employee’, ‘Humaresources’

how to map local server login to remote server login in linked servers – SQL Server

syntax: EXEC sp_addlinkedsrvlogin ‘linked servername’, ‘false’, ‘local login’, ‘remote login name’, ‘remote login password’

EXEC sp_addlinkedsrvlogin ‘LNK_PROD’, ‘false’, ‘domain\abc’, ‘user1’, ‘Password!’