how much datas we can store in a table

hello world,
we r developing a software for our company.one table is for client support
and feedback.in tht table more than one pages of datas has to be inserted pe
r
client.is this possible?if not is it possible to shift the datas in tht tabl
e
to other table automatically when tht table is full.if so pls send the
queries for tht.Hi
There are limits to things like number of columns in a table and size of
database see:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
The number of rows your table contains is limited by your hardware
constraints.
It is not clear exactly what you require, if you wish to archive/delete old
data, then you will need a means of identifying that data, but you don't giv
e
any information regarding your table structure or data. Posting DDL (Create
table statements etc...) http://www.aspfaq.com/etiquette.asp?id=5006 and
example data as insert statements http://vyaskn.tripod.com/code.htm#inserts
would help.
To periodically run your archive task check out SQLAgentService in books
online and how to create/run jobs or at
http://msdn.microsoft.com/library/d...br />
6x0l.asp
John
"nikhil" wrote:

> hello world,
> we r developing a software for our company.one table is for client support
> and feedback.in tht table more than one pages of datas has to be inserted
per
> client.is this possible?if not is it possible to shift the datas in tht ta
ble
> to other table automatically when tht table is full.if so pls send the
> queries for tht.
>