Re: Table problem ?

Are you sure this is not the table corruption problem ?


"Joh" <joh@xxxxxxxxxxxx> wrote in message
news:uoKtWZTQFHA.2876@xxxxxxxxxxxxxxxxxxxxxxx
> 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 ?
    ... Last shot for me is: ... Could be an corrupt index there. ... Jens. ... Prev by Date: ...
    (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: Corrupt attatchments since upgrade to Tiger
    ... >I never used LS but still had the same corruption problem. ... > on MacFixit.com states the same solution as removing LS, ... > that's the same between LittleSnitch and NetBarrier... ... Prev by Date: ...
    (microsoft.public.mac.office.entourage)
  • Re: Corrupt attatchments since upgrade to Tiger
    ... I never used LS but still had the same corruption problem. ... on MacFixit.com states the same solution as removing LS, ... that's the same between LittleSnitch and NetBarrier... ... Prev by Date: ...
    (microsoft.public.mac.office.entourage)
Loading