Re: Table problem ?

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
Loading