In this post, let us see how to create linked server between On-premise and Azure SQL database and after establishing linked server, how we can query Azure SQL database & create objects in Azure SQL database from local On-premise SQL Server.
I am going to create a table and insert sample data in my Azure SQL database, so that after creating linked server I can query this sample object from my local On-premise SQL Server.
Now let us try to create table in Azure SQL database from local On-premise SQL Server, below is the syntax but it will throw error, we need to enable RPC out in Linked server property.