How many records in a table?

Hi! Stupid question as this also depends on hardware but is there a limit on
how many rows I can have in a single MSSQL 2000 table? Table consists of six
int columns and has three indexes. Is like 10 Million or 100 Million
considered to be 'normal' or unrealistic?

Thanks very much for your thoughts!

MartinMartin,

It's actually limited ONLY by hardware (disk space). I wouldn't say that 10
or 100 million are anywhere near "unrealistic". Maybe 1 trillion would be
more like it!

"Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
news:cit9ft$m5b$1@.hercules.btinternet.com...
> Hi! Stupid question as this also depends on hardware but is there a limit
on
> how many rows I can have in a single MSSQL 2000 table? Table consists of
six
> int columns and has three indexes. Is like 10 Million or 100 Million
> considered to be 'normal' or unrealistic?
> Thanks very much for your thoughts!
> Martin|||Thanks!

"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:4152361a$0$2656$61fed72c@.news.rcn.com...
> Martin,
> It's actually limited ONLY by hardware (disk space). I wouldn't say that
> 10
> or 100 million are anywhere near "unrealistic". Maybe 1 trillion would be
> more like it!

How Hide Colum Headings

I have a report that consists of 4 groups representing 4 levels of grouped
data with separate column headings and no detail rows as follows:
ColHeading 1
Level 1
ColHeading 1.2
Level 1.2
ColHeading 1.2.1
Level 1.2.1
ColHeading 1.2.2
Level 1.2.2
The report always prints a column heading at each level even when no data is
printed at that level. I have tried using the invisibility test as follows:
-Select ColHeading 1.2 row
-Test for existance of first cell in Level 1.2
-Get error that item is out of scope
Can this be done?
Many thanks!It's ugly, but if you're using sprocs, you can dump your data to TABLE
variables, then check for the existence of data in subordinate levels, then
update those values in the parent. This isn't particularly elegant, and
it's slower than it should be, but I've had to resort to this kind of thing
with SRS before. HTH.
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:uUv6jhD$EHA.2788@.TK2MSFTNGP15.phx.gbl...
>I have a report that consists of 4 groups representing 4 levels of grouped
>data with separate column headings and no detail rows as follows:
> ColHeading 1
> Level 1
> ColHeading 1.2
> Level 1.2
> ColHeading 1.2.1
> Level 1.2.1
> ColHeading 1.2.2
> Level 1.2.2
> The report always prints a column heading at each level even when no data
> is printed at that level. I have tried using the invisibility test as
> follows:
> -Select ColHeading 1.2 row
> -Test for existance of first cell in Level 1.2
> -Get error that item is out of scope
> Can this be done?
> Many thanks!
>