RPC vs OPENROWSET

• SQLdba-473999

  SSCrazy

  Points: 2761

  More actions

  November 4, 2008 at 9:05 am

  #131966

  Which is the better/more secure option to go with when getting a remote query to run on a server?

  1. Enable OPENROWSET option

  2. Create a linked server and set RPC to True

• Elisabeth Rédei

  Hall of Fame

  Points: 3873

  More actions

  November 4, 2008 at 2:53 pm

  #893916

  Hi,

  Definitely the linked server. For more information see http://msdn.microsoft.com/en-us/library/ms187569(SQL.90).aspx "Ad Hoc Distributed Queries Option".

  HTH!

  /Elisabeth

  elisabeth@sqlserverland.com
  MCITP | MCT
  http://sqlblog.com/blogs/elisabeth_redei/
  http://linkedin.com/in/elisabethredei