Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Server Agent jobs running under SA RE: SQL Server Agent jobs running under SA

  • June 21, 2013 at 5:48 am

    #1626289

    jasona.work (6/20/2013)

    OK, I don't know if this might help, but I found a similar issue elsewhere:

    Link to topic

    ...

    (PS, I do see on one of my servers in sysprocesses an NTLogin showing a LoginName of SA right now. This is for the "FSAgent Task" which some quick Googleing shows as being used by the FileStream feature (which we are using))

    OMG. That is exactly the same issue I'm having with SQL Server.

    I don't think we're using the FileStream feature. But since you bring it up, how would I check to be sure?

    EDIT: Interesting comment on that thread is that the procs were created by the SA account. My boss (who is also sysadmin) created the proc we are using. So far as I know, he didn't log in as SA to do it either. So maybe the recompile comment is on the money? Then again, as you mentioned, this is sybase, not SQL Server.

    Does anyone know if the creator of procs are listed anywhere? I know that sysobjects has the schema ID. I'm looking for the identity of the login that actually ran the CREATE PROCEDURE statement.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.