Posted by CK on 10/13/31 11:32

Thanks for letting me know about this command. Otherwise I would have waited
forever without realising the process is in the state of "sleeping".


"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:e3hsn15bpfht5a1i452ros2i19dhsh2hjc@4ax.com...
> On Thu, 17 Nov 2005 23:19:08 +1100, CK wrote:
>
>>Is this normal?
>
> Hi CK,
>
> Two days for indexing? No, that's not normal.
>
> Open a new window in Query Analyzer and execute sp_who2. I think that
> something is blocking your indexing process.
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]