Re: Any way to get at ANY data from a table that is "hanging" when you access it?
From: Larry Woods (larry_at_NOSPAMlwoods.com)
Date: 06/28/04
- Next message: Ian Boyd: "Re: Pulling Data into One Query Fomr Two Databases\Tables"
- Previous message: a: "Tracking Data Changes"
- In reply to: Aaron [SQL Server MVP]: "Re: Any way to get at ANY data from a table that is "hanging" when you access it?"
- Next in thread: Aaron [SQL Server MVP]: "Re: Any way to get at ANY data from a table that is "hanging" when you access it?"
- Reply: Aaron [SQL Server MVP]: "Re: Any way to get at ANY data from a table that is "hanging" when you access it?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Jun 2004 14:07:26 -0700
The NOLOCK allows me to display the table
How do I release the LOCK?
Larry Woods
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:%23ToEFwTXEHA.556@tk2msftngp13.phx.gbl...
> > I am assuming that I have a "crashed" table on my database. I can get
> into
> > other tables on the database but when I try to query a particular table
I
> > hang until timed out.
>
> Did you try
> SELECT TOP 1 * FROM tbl WITH (NOLOCK)
> ?
>
> > ANY way to attempt any sort of analysis of "why" this is happening?
And,
> > any recovery besides complete DB recovery?
>
> Profiler/perfmon (check locks etc), DBCC OPENTRAN, sp_who2 + DBCC
> INPUTBUFFER...
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
- Next message: Ian Boyd: "Re: Pulling Data into One Query Fomr Two Databases\Tables"
- Previous message: a: "Tracking Data Changes"
- In reply to: Aaron [SQL Server MVP]: "Re: Any way to get at ANY data from a table that is "hanging" when you access it?"
- Next in thread: Aaron [SQL Server MVP]: "Re: Any way to get at ANY data from a table that is "hanging" when you access it?"
- Reply: Aaron [SQL Server MVP]: "Re: Any way to get at ANY data from a table that is "hanging" when you access it?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
