Presents your 
SQL SERVER E-NEWSLETTER for February 20, 2003

<------------------------------------------->

MAINTAIN A TABLE ON ALL DATABASE OBJECTS

In a SQL Server database, it's good practice to maintain a table that
lists all the database objects and the types of database objects that 
are identified as production objects. You can use this table to create 
scripts with greater flexibility.

For example, you can use the table to generate scripts that:

* Replicate database publication.
* Add tables to the database.
* Delete tables from the database.

One of the most essential functions of this table is to identify which
database objects are production database objects and which database
objects are rogue database objects. This is most beneficial if you have a
product that contains SQL Server database(s), and you maintain many 
sites for this product.

This table also establishes a clean schema of database objects that help
make auditing easier. Schema objects can include declared referential
integrity objects, clustered and nonclustered indexes, user triggers,
extended properties, and collation.

----------------------------------------