How to Link to another server using SQL Query

Posted on Sunday, 12 April 2020

SQL: Link to another server using SQL Query

Description

The data can be saved on different servers and can be accessed. This is the query that can be used to another servers using the Sql Server.

Syntax

The syntax in the SQL Server for the GROUP BY clause is as following :


EXEC sp_addlinkedserver @server='192.1111.1111.111'




EXEC sp_addlinkedsrvlogin '192.1111.1111.111', 'false', NULL, 'geeta', 'paasword'

0comments

Post a Comment