Post reply

When is a SPID assigned to a different user?

  • June 13, 2019 at 5:44 pm

    #3653383

    Hi,

    I am trying to track down a configuration change that was made to a database. The recovery mode was set from simple to full and the log drive filled up causing production issues. No one who has access to make this change remembers (or will admit to) doing it. I see the time of the change and the SPID in the SQL log. The change was made on June 11. On June 13, sp_who2 shows someone currently assigned to this SPID, but it's sleeping. Is it possible this SPID was assigned to someone else on 6/11? Does a SPID persist no matter what? Or is there some way to know now who was assigned to this SPID 2 days ago?

     

    Thanks!

    • This topic was modified 5 years, 6 months ago by  agerard 65681.

  • June 13, 2019 at 5:53 pm

    #3653387

    It doesn't persist. Once session is over that specific number can be re-assigned to another session.

    --Vadim R.

  • June 13, 2019 at 7:20 pm

    #3653459

    If you know the date and time, you might be able to dig it out of the default trace files if it's still available there. It won't have the exact change, it would show up ObjectAltered and the database ID. Or look at the built in report -  schema change report. It would show up there. Both would have the login, not just the spid.

    Sue

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

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