Generate SQL Script

Hi,
To generate SQL script, we can right click the database in SQL Server
Enterprise Manager. But is there any way that I can schedule to generate
this script automatically?
Thank you for your help, and any feedback will highly appreciated.
BillyYes. You can hijack the sample DMO code that comes with SQL and alter it to
script out your objects to a text file using a win32 DTS task scheduled in a
job..
"Billy Leung" wrote:
> Hi,
> To generate SQL script, we can right click the database in SQL Server
> Enterprise Manager. But is there any way that I can schedule to generate
> this script automatically?
> Thank you for your help, and any feedback will highly appreciated.
>
> Billy
>
>