Is there a way for SP to know who called it?

• water490

  Ten Centuries

  Points: 1147

  More actions

  September 20, 2025 at 8:19 pm

  #4655318

  Hi everyone

  I am writing an SP where there is logic inside the SP that depends how the SP was called.  For example,

  Start of SP

  ....code....

  If SSIS called SP then do A else do B

  .... code ....

  End of SP

  Is there a way for SP to know who asked it to run?  In my case, the choice would be either SSIS ran the SP or I manually ran it.

  Thank you

• pietlinden

  SSC Guru

  Points: 63598

  More actions

  September 20, 2025 at 8:28 pm

  #4655319

  It already "knows"... That's what SYSTEM_USER returns. For example...

  SELECT SYSTEM_USER AS WindowsAccount, be.*
  FROM Bakery.dbo.BakeEvents be;

  I know, looks really stupid, but the first column is the user running the query or the account it's being run under.

  Maybe you want to dump it into a conditional split sort of thing where if it's "User A", do one thing, and if it's "User B" do something else.