Just a small note. It might be better to maintain database documentation rather than the ERD. the use of tools such as Redgates Sql Doc is far more efficient than...

saw this

http://www.amazon.com/Practical-Business-Intelligence-Microsoft-Windows/dp/0321356985/ref=cm_lmf_tit_10_rdssss0

Practical Business Intelligence with SQL Server 2005 (Microsoft Windows Server System Series) (Paperback)

by John C. Hancock (Author), Roger Toren (Author) pb date 2006

the reviews look interesting

adamcrv -

I would appreciate the elaboration

I am trying to replication both views and stored procedures

we made the attempt to generate the replicate stored procedures sp_..._1 to sp_...<table_name>

performed an update to a record

still said sp not found

I use ultraedit for many things. Reading the scripts from ms sql server, html, and even large TEXT files [ > 25Mb] with problems of embedded characters.... for $30 best...

Great review of features from DB2 manager and Sql server

I had worked on a UDB [ aka DB2 v8] and found the inteface awful... the best tool for UDB is...

on the subject of extraction -- It is a sure thing to use a stage table . Then, ADD views to pre-parse your data including the exception file. Now use...

ETL tools of the past are : DataStage now part of the Ascentials suite w/ IBM; Sagent; and Ab Initio [ a new comer] ... all above $80k Good...