August 5, 2008 at 1:18 pm
I need help trying to figure out how the SPID # is assigned in SQL2k. I have a db, that had a process running, that ended up dropping a bunch of tables. I have given the developers a copy of report from a log analyzer, that shows the same SPID running a bunch of "normal" transactions, then a few minutes later running the drop tables. Can somebody point me in the right direction here for where to find what I'm looking for?
August 6, 2008 at 1:53 am
I'm afraid you won't find what you're looking for by looking at SPID's.
Basically whenever a new connections is made to SQL Server it will get the lowest free SPID which is higher than 50. Up to 50 are spids reserved for system processes, above is for users.
So if you look only at the SPID # without the user and/or login time you might get wrong results. The same spid can be assigned to different users. In your case user one could have done some "normal" actions, then disconnected. User 2 connects and gets the same Spid assigned and then deletes your tables.
Hope this is clear enough.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply