DB Schema / Architecture software assessment tools?

Hello all,
I have been asked to research the tools available for reporting database
schema / links within SQL 2000.
I need a tool which will go through objects and also stored procedures /
queries and report all references / links. The idea being to end up with a
complete list of items in a db and what is effected by each.
Has anyone used such a tool or perhaps knows of one they could recommend I
look into?
All help is greatly appreciated, Simon.Not so sure about the dependencies but you might want to check out these:
http://www.imceda.com/Change_Management.htm
www.red-gate.com
http://www.innovartis.co.uk/home.aspx
Andrew J. Kelly SQL MVP
"Simon" <reply@.togroup.com> wrote in message
news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have been asked to research the tools available for reporting database
> schema / links within SQL 2000.
> I need a tool which will go through objects and also stored procedures /
> queries and report all references / links. The idea being to end up with a
> complete list of items in a db and what is effected by each.
> Has anyone used such a tool or perhaps knows of one they could recommend I
> look into?
> All help is greatly appreciated, Simon.
>
>|||thank you but these tools relate to backups, rolling out from test platform,
database design but not analysis of current schema.
Any other suggestions would be appreciated, thanks again, Simon.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:emueAUqOFHA.3828@.TK2MSFTNGP10.phx.gbl...
> Not so sure about the dependencies but you might want to check out these:
> http://www.imceda.com/Change_Management.htm
> www.red-gate.com
> http://www.innovartis.co.uk/home.aspx
>
> --
> Andrew J. Kelly SQL MVP
>
> "Simon" <reply@.togroup.com> wrote in message
> news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Hello all,
>> I have been asked to research the tools available for reporting database
>> schema / links within SQL 2000.
>> I need a tool which will go through objects and also stored procedures /
>> queries and report all references / links. The idea being to end up with
>> a complete list of items in a db and what is effected by each.
>> Has anyone used such a tool or perhaps knows of one they could recommend
>> I look into?
>> All help is greatly appreciated, Simon.
>>
>