Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server ...