sid location in db for users in a windows group

• Joshua D Gang

  Ten Centuries

  Points: 1126

  More actions

  September 20, 2011 at 2:08 pm

  #257640

  I have a SQL job that is owned by me. I do not have a specific login to the SQL server but the Windows SG I am part does. I am trying to write a report that shows all jobs and owner. I cannot find which table contains the sid that relates to me. The group I am part of is located in the sys.server_principles, the table which I am joining on to find the owners name.

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  September 21, 2011 at 1:38 pm

  #1384770

  Use SUSER_SNAME():

  SELECT name,

  SUSER_SNAME(owner_sid) AS job_owner

  FROM msdb.dbo.sysjobs

  ORDER BY name ;

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Joshua D Gang

  Ten Centuries

  Points: 1126

  More actions

  September 21, 2011 at 2:20 pm

  #1384802

  Thank you.

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  September 21, 2011 at 2:50 pm

  #1384824

  You're welcome, HTH.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato