SQL Azure Linked Servers

EXEC master.dbo.sp_addlinkedserver @server = N’FriendlyName’, @srvproduct=N”, @provider=N’sqlncli’, @datasrc=N’mydb.DATABASE.WINDOWS.NET’, @catalog=N’DBNAME’ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N’FriendlyName’,@useself=N’False’,@locallogin=NULL,@rmtuser=N’SQLUSER’,@rmtpassword=’Password’

http://yasqlsb.blogspot.com/2014/07/sql-azure-linked-servers.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s