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.comNo
--
Andrew J. Kelly SQL MVP
"Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d871d8b5bf1642a6bfca78c03646a764@.SQLMonster.com...
> 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment