SQL cross-Server Query

Select. *, B. * From OpenRowSet ('msdasql ', 'driver = {SQL Server}; server = 119.254.245; uid = sa; Pwd = abc123_kxr', mall_master.dbo.product) as a, kxr_products B -- where, tom is the remote server name, and stores is the table in the local database pubs. Note that if the number of records in the two tables is different, a table will generate completely duplicate rows, -- the number of rows in the table with the longest record set is insert into DBO. kqmx_200704select * From OpenRowSet ('msdasql ', 'driver = {SQL Server}; server = 192.168.1.253; uid = sa; Pwd =', one. DBO. kqmx_200704) 1. Assume that the local server is 192.168 . 0.1, remote server 192.168.0.2. 2. Create a user on the 192.168.0.2 server: User, password: 000 3. Execute the following statement on the 192.168.0.1 server: exec sp_add1_server 'srv _ lnk ', '', 'sqloledb ', '2017. 168.0.2 'exec sp_add1_srvlogin 'srv _ lnk ', 'false', null, 'user', '000' go 3. The following is an example of database query for local access to 192.168.0.2: select * From srv_lnk. database Name. DBO. table name 4. Delete the linked server exec sp_dropserver 'srv _ lnk ', 'droplogins' go