restrict size of datatable

[Daniel]

hi all.

i am developing a database application with sqlserver2000 where users
can enter search strings manually.
So it is possible that the result gets really big, to big for a website.
is it possible to restrict a datatable to a defined number of rows, or
bytes?
or maybe there is s.th. in t-sql?

thangs for help.
daniel

 

[Earl]

Use either SELECT TOP and/or SET ROWCOUNT in SQL2K.