Posted by Tibor Karaszi on 06/26/06 18:36

Possibly this can be of help. Seems it isn't released quite yet, though:

http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"batman" <uspensky@gmail.com> wrote in message
news:1151334096.716911.238760@i40g2000cwc.googlegroups.com...
> we have a group of developers which have created and asked us (DBAs) to
> create many objects in the databases including tables / stored
> procedures / functions / etc.
>
> since our company is growing, however we have an increasing amount of
> objects that have either been abandoned or have several versions.
>
> in an effort to clean of the huge amount of clutter and anytime that
> something simple like a stored proc needs to change, it is almost
> impossible to predict exactly where we will see negative effects of
> this change.
>
> i am looking for a system (preferably without developing our own tool)
> that would keep track of history of database objects (in terms of who
> created it and what purpose it has) as well as link that to all the
> developers/users we might need to notify of any changes to that object.
> Also, this should be linked to the application which rely on the
> object.
>
> bottom line... every object in the database needs to have at least 1
> corresponding contact as well as the applications which us it.
>
> with this information, we can much more easily maintain objects in our
> DBs.
>
> thx
>

[Back to original message]