AZR-SQL101 Linkend server from regular MS-SQL server to AZURE
USE [master] GO EXEC master.dbo.sp_addlinkedserver @server = N'<<Friendly Name>>' , @srvproduct=N'' , @provider=N'sqlncli' , @datasrc=N'<<AzureSqlServerName>>.DATABASE.WINDOWS.NET' , @catalog=N'<<databasename>>' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'AZR_RSZK_STG' , @useself=N'False' , @locallogin=NULL , @rmtuser=N'<<LocalAccount>>' , @rmtpassword='<<VeryStrongPassword>>' Till Next Time