How can I import certain database objects(tables, stored procedure, etc.) based on the date they have been created?

OOh good Q.

What I would do is use SQLDMO. Both Table and StoredProcedure have a
CreateDate property. I would then script these out to a file as an ALTER or
CREATE statement and reapply them on the other server.



--

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


"Simona" <anonymous (AT) discussions (DOT) microsoft.com> wrote