Linked Server setup

Last Post 10 Jan 2014 08:12 AM by dbandee. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dbandee
New Member
New Member

--
09 Jan 2014 08:33 AM
hi
happy new year everyone

we are trying to get away with using Linked Severs in our env
but how do i execute remote scripts or call another job on remote server without Linked Server?

thanks
russellb
New Member
New Member

--
09 Jan 2014 09:36 AM
See http://technet.microsoft.com/en-us/....aspx#SSMS for executing jobs on a remote server.

Have a look at OpenDataSource and OpenRowset for executing T-SQL batches on remote servers. Know that these essentially create a linked server for the duration of the session.

http://technet.microsoft.com/en-us/...79856.aspx

Why don't you want to create linked servers?
dbandee
New Member
New Member

--
10 Jan 2014 08:12 AM
we want to get rind of qa to test and test to qa linked severs
if we have qa to qa serevrs linked for example its ok
You are not authorized to post a reply.

Acceptable Use Policy