DB Sizes

hi,

i'm planning to create a DB of about 1TB of text.

can SQL EXPRESS handle this sizes of data? what about SQL 2005?

does it matter if i put all the data in 1 table?

Thanks.

SQL Express can handle a db size of maximum 4 GB(max db size) ! ! pls refer the below link,
http://download.microsoft.com/download/4/2/c/42c6af76-a28c-4560-8269-e8fe906ea675/SQLExpressdatasheet.pdf

for sql 2005 pls refer the below link,
http://technet.microsoft.com/en-us/library/ms143432.aspx

you can go for table partioning in sql 2005 refer
http://sql-articles.com/articles/part/PARTITIONING.htm

Thanxx
Deepak