Re: Table problem ?

Last shot for me is:

DBCC DBREINDEX (<name>, '', 0)

Could be an corrupt index there.

Jens.



"Joh" <joh@xxxxxxxxxxxx> schrieb im Newsbeitrag
news:OOpwTOTQFHA.3288@xxxxxxxxxxxxxxxxxxxxxxx
> no effects, still same problem .... any other tips?
>
> Thanks in advance.
>
> "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
> in
> message news:usL5mLTQFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
>> That does it for all user tables in the databases.
>>
>> HTH, Jens Süßmeyer.
>>
>>
>> "Joh" <joh@xxxxxxxxxxxx> schrieb im Newsbeitrag
>> news:eeeiLETQFHA.1932@xxxxxxxxxxxxxxxxxxxxxxx
>> > EXEC sp_updatestats (is it ample?)
>> >
>> > Thanks
>> >
>> >
>> >
>> > "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
>> > wrote
>> > in
>> > message news:uglT$4SQFHA.2736@xxxxxxxxxxxxxxxxxxxxxxx
>> >> Try updating manually the statistics, perhaps the problem canbe found
>> > here:
>> >>
>> >>
>> >
> http://groups.google.de/groups?q=update+statistics+sql+server&hl=de&lr=&selm
>> > =5OAzWbPWEHA.3468%40cpmsftngxa10.phx.gbl&rnum=1
>> >>
>> >>
>> >> UPDATE STATISTICS <Name>
>> >>
>> >>
>> >> HTH, Jens Süßmeyer.
>> >>
>> >> ---
>> >> http://www.sqlserver2005.de
>> >> ---
>> >>
>> >> "Joh" <joh@xxxxxxxxxxxx> schrieb im Newsbeitrag
>> >> news:e0H%234tSQFHA.2252@xxxxxxxxxxxxxxxxxxxxxxx
>> >> >I have one table which name is medicalhistory which structure is as
>> >> >follows.
>> >> >
>> >> > ID int
>> >> > TId int
>> >> > TableName nvarchar(100)
>> >> > FieldName nvarchar(100)
>> >> > Comm1 nvarchar(4000)
>> >> > Comm2 nvarchar(4000)
>> >> > CDate datetime
>> >> > SCDate datetime
>> >> >
>> >> > The problem is that when I use the following query like.
>> >> >
>> >> > select count(*) from medicalhistory
>> >> >
>> >> > It is continously running and doesn't give me any result, so I get
> the
>> >> > count
>> >> > from the following query
>> >> >
>> >> > select rowcnt from sysindexes where id = object_id('medicalhistory')
>> >> >
>> >> > 12819530
>> >> >
>> >> > There is no index in the above table and I also use the following
>> > command
>> >> > for consistency error.
>> >> >
>> >> > DBCC Checktable ('medicalhistory')
>> >> >
>> >> > Result:-
>> >> > DBCC results for 'medicalhistory'.
>> >> > There are 12819530 rows in 218027 pages for object 'medicalhistory'.
>> >> > DBCC execution completed. If DBCC printed error messages, contact
> your
>> >> > system administrator.
>> >> >
>> >> > Even when I use this command like
>> >> >
>> >> > select * from medicalhistory where ID = 523662
>> >> >
>> >> > It is continously running and doesn't give me any result
>> >> >
>> >> > Can any one give me his or her expert idea like this is the table
>> >> > corruption
>> >> > or what the problem is ?
>> >> >
>> >> > What I have to do now?
>> >> >
>> >> > Thanks in advance.
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>


.

Relevant Pages

  • Re: Table problem ?
    ... Lemme check and update you! ... > Last shot for me is: ... > Could be an corrupt index there. ... > Jens. ...
    (microsoft.public.sqlserver.clients)
  • Re: Table problem ?
    ... > Lemme check and update you! ... >> Could be an corrupt index there. ... >> Jens. ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • Re: Table problem ?
    ... Are you sure this is not the table corruption problem? ... >>> Could be an corrupt index there. ... >>> Jens. ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • Re: Beginner dokumentation
    ... > things like(according to linux): ... > -how the boot concept works ... All trespassers will be shot, ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Beginner dokumentation
    ... > things like(according to linux): ... > -how the boot concept works ... All trespassers will be shot, ...
    (comp.unix.bsd.freebsd.misc)
Loading