Re: Table problem ?

sorry Man... same issue !

I think there is some big problem in this table.


"Joh" <joh@xxxxxxxxxxxx> wrote in message
news:OhRS7VTQFHA.648@xxxxxxxxxxxxxxxxxxxxxxx
> Lemme check and update you !
>
> "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in
> message news:OGaAOUTQFHA.1472@xxxxxxxxxxxxxxxxxxxxxxx
> > 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 ?
    ... Last shot for me is: ... 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: Haiti-- Démission membres Conseil des sages (SURPLUS)
    ... Lemme guess..... ... power struggle. ... Prev by Date: ...
    (soc.culture.haiti)
  • Re: SQL Server on Linux - reality!!!!
    ... "Please login to read this article" ... Lemme guess: April Fools? ... Prev by Date: ...
    (borland.public.delphi.non-technical)
Loading