sql server 2000 dependency script

[smythe]

I need a script that will generate a file containing all dependencies in sql server 2000? Any ideas where I can get one of these or where to start?

I know you can view the dependencies in the interface, but I need to output ALL dependencies to a file.

thanks for any help

 

[TheBugSlayer]

If you use the wizard in EM to generate the scripts, in the Formatting table check the option 'Generate Scripts For All Dependent Objects'.

Hope this helps.

 

[smythe]

Thanks, I actually ended up writing a modified version of the available

[dbo].[sp_MSdependencies]

stored procedure and got what I needed.