Sunday, February 12, 2012

Anyway to trace the origin of a SPID once server is rebooted?

Received a db error when I was in a conference
Process 49 unlocking unowned resource: DB: 1
and SQL server stopped and tried to recover.
In a panic my team rebooted the server (which resolved the issue)
Since the reboot occurred I couldn't see what was SPID 49.
After the reboot is there a way in the sys tables to see what SPID49 was at
a given time?
Jeff
Message posted via http://www.sqlmonster.com
No
Andrew J. Kelly SQL MVP
"Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d871d8b5bf1642a6bfca78c03646a764@.SQLMonster.c om...
> Received a db error when I was in a conference
> Process 49 unlocking unowned resource: DB: 1
> and SQL server stopped and tried to recover.
> In a panic my team rebooted the server (which resolved the issue)
> Since the reboot occurred I couldn't see what was SPID 49.
> After the reboot is there a way in the sys tables to see what SPID49 was
> at
> a given time?
> Jeff
> --
> Message posted via http://www.sqlmonster.com

No comments:

Post a Comment