Post reply

Job/database owner name

  • September 28, 2008 at 11:12 pm

    #123876

    Hi,

    I am trying to build a list of all job/database owners on the server. In case the login gets access to SQL Server via group membership it does not have an entry in syslogins table and I can't join to that table. Sysjobs table only has owner's sid. How do I query the owner name when the login is not in the syslogins table using TSQL?

    Thanks.

  • September 29, 2008 at 12:11 am

    #878261

    Found it: suser_sname(sid)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply