Yep

You need to use the SQLDMO object library. I would recommend doing this in
VBScript not TSQL (although it can be done) and use SQL Server Agent to do
the scheduling




--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"SQL DBA" <SQLDBA (AT) discussions (DOT) microsoft.com> wrote

You can use the Copy SQL Server Objects Task - there's an option inside where you can move the schema only.