running sp in a linked server environment.

• savenbuan

  SSC Veteran

  Points: 243

  More actions

  October 2, 2001 at 10:02 am

  #57995

  Please help. My brain seems to be blocked today.

  I am trying to run a system stored proceedure from a link server but it is not working.

  EG running sp_help or sp_who from my local machine on all or one of my linked server.

  Somebody to my rescue.

  Sonn

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 2, 2001 at 10:11 am

  #418607

  Exec server.master.dbo.sp_help, you have to have RPC out enabled for the linked server I think.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  October 2, 2001 at 10:23 am

  #418609

  Linked servers require the 4 part name (server.db.owner.object)

  Steve Jones

  steve@dkranch.net