- Create a link server EXEC SP_ADDLINKEDSERVER 'LINKNAME', '', 'SQLOLEDB', 'Remote Server Name or IP Address' Exec Sp_addlinkedsrvlogin' LinkName ',' False ', Null,' User Name, 'Password' Go
Select * from linkname. Database name. dbo. Table name
SELECT * INTO Table from linkname. Database name .dbo. Table name
GoExec sp_dropserver 'linkname', 'droplogins'select * from openrowset (' sqloledb ',' sql server name); 'username'; 'password', database name. dbo. Table name)
- Importing Example Select * INTO Table from OpenRowSet ('Sqloledb', 'SQL Server Name;' User Name; 'Password', Database Name .DBO. Table Name)
