Maximum number of records SQL 2000

Hi,
What is the maximum number of records I can have in a SQL 2000 table? or Is
there a max.
Thanks
MikeI don't know the exact answer, but I am positive that
that limit is so high that you can say there is no limit,
because before you hit that limit you will hit the limit
on your filesystems.
>--Original Message--
>Hi,
>What is the maximum number of records I can have in a SQL
2000 table? or Is
>there a max.
>Thanks
>Mike
>
>.
>|||In terms of how many records can be in a table depends on
how much info is in each record. Theoretically SQL Server
can handle up to a Terabyte of data (1,000 Gigabytes).
Hope this helps.
Chad
>--Original Message--
>Hi,
>What is the maximum number of records I can have in a SQL
2000 table? or Is
>there a max.
>Thanks
>Mike
>
>.
>|||The answer like any performance question is 'it depends'.
I've worked on big ES7000 boxes with 300 million row tables. It's all a
function of the hardware and what you're trying to do with the data.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Chad" <ChadLucy@.msn.com> wrote in message
news:045301c38dca$f004ea30$a101280a@.phx.gbl...
> In terms of how many records can be in a table depends on
> how much info is in each record. Theoretically SQL Server
> can handle up to a Terabyte of data (1,000 Gigabytes).
> Hope this helps.
> Chad
> >--Original Message--
> >Hi,
> >
> >What is the maximum number of records I can have in a SQL
> 2000 table? or Is
> >there a max.
> >
> >Thanks
> >
> >Mike
> >
> >
> >.
> >|||> Theoretically SQL Server
> can handle up to a Terabyte of data (1,000 Gigabytes).
According to the Books Online, rows per table is 'Limited by available
storage'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Chad" <ChadLucy@.msn.com> wrote in message
news:045301c38dca$f004ea30$a101280a@.phx.gbl...
> In terms of how many records can be in a table depends on
> how much info is in each record. Theoretically SQL Server
> can handle up to a Terabyte of data (1,000 Gigabytes).
> Hope this helps.
> Chad
> >--Original Message--
> >Hi,
> >
> >What is the maximum number of records I can have in a SQL
> 2000 table? or Is
> >there a max.
> >
> >Thanks
> >
> >Mike
> >
> >
> >.
> >|||"Mike R" <n@.nospam.co.uk> wrote in message
news:bm1fml$301$1$8302bc10@.news.demon.co.uk...
> Hi,
> What is the maximum number of records I can have in a SQL 2000 table? or
Is
> there a max.
> Thanks
> Mike
>
Thanks for all you help
Kind Regards
Mike