How to make a smaller size database from a huge size database

Could anyone teach me how make a smaller size of database out of a huge size database? The smaller sized DB should have exactly the same schema as the big size one. THanks in advance and your help is highly appreciated.
Kuilian
Kuilian,
you could replicate all the tables and use horizontal filters to restrict
the number of rows.
HTH,
Paul Ibison
|||Thanks, Paul! If I want to get a smaller size database based on some criteria, how can I pass those criterias? --kuilian
"Paul Ibison" wrote:

> Kuilian,
> you could replicate all the tables and use horizontal filters to restrict
> the number of rows.
> HTH,
> Paul Ibison
>
>
|||KT,
the filter rows tab on the publication properties will allow you to enter
your criteria.
HTH,
Paul Ibison

How to know what schema was modified

Hello,

Is there a way in MSSQL server to find all the objects in the database
based on the modified date rather than the created date.

Thanks in advance
Kumuunfortunately, sqlserver does not store such info. so, you can't.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net

"kumu" <forlist2001@.yahoo.com> wrote in message
news:a44abd39.0311191320.6e962c15@.posting.google.c om...
> Hello,
> Is there a way in MSSQL server to find all the objects in the database
> based on the modified date rather than the created date.
> Thanks in advance
> Kumu