"SAC" <sac@somewhere.com> wrote in message
news:%23%23%23VbCJGHHA.3468@TK2MSFTNGP04.phx.gbl...
>I have a view with several tables....every now and then it won't open so I
> check each table in the view and there has been one that won't open so I
> have to copy it from a backup .
>
> Any idea as to why a table won't open when there's no maintenance done to
> it?
>
> Thanks.
>
>

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%23POObIOGHHA.4116@TK2MSFTNGP05.phx.gbl...
> Hello,
>
> Might be because the table is locked fully. Just execute SP_WHO in a
> seperate session and see of there is any blocking. Also execute a DBCC
> CHECKDB on the
> database and see if there is any corruption. Mostly this will occur if the
> table is locked....
>
> Thanks
> Hari
>
>
> "SAC" <sac@somewhere.com> wrote in message
> news:%23%23%23VbCJGHHA.3468@TK2MSFTNGP04.phx.gbl...
>>I have a view with several tables....every now and then it won't open so I
>> check each table in the view and there has been one that won't open so I
>> have to copy it from a backup .
>>
>> Any idea as to why a table won't open when there's no maintenance done to
>> it?
>>
>> Thanks.
>>
>>
>
>