EXEC master.dbo.sp_addlinkedserver
       @server = N'AzureTest',
       @srvproduct=N'Any',
       @provider=N'MSDASQL',
       @datasrc=N'AzureTest'
GO


EXEC master.dbo.sp_addlinkedsrvlogin
       @rmtsrvname=N'AzureTest',
       @useself=N'False',
       @locallogin=NULL,
       @rmtuser=N'user@gmail.com@XXXX',
       @rmtpassword='XXXX'
GO