Linked server execution source-server

• R-640598

  Valued Member

  Points: 62

  More actions

  February 14, 2008 at 10:50 am

  #70802

  I have ServerA and ServerB attached both ways with linked-servers.

  When ServerA executes something like :

  [ServerB].Database.dbo.Stored_Procedure @Parameter

  I want Stored_Procedure to know that ServerA is where the transaction is originating.

  Other than checking that the user is the one defined in the linked-server definition(I am using SQL Server authentication for the linked servers), is there any other way to know the query is originating from another instance/server?

  Thanks!

  CKC

• R-640598

  Valued Member

  Points: 62

  More actions

  February 14, 2008 at 11:25 am

  #778505

  Something like @@remserver... but for linked servers.

  @@remserver works fine right now but is to be deprecated in SS2008, so I can't use it.

  I checked MSDN and there is no replacement offered. I assume since there is already a linked server equivalent.