It’s always hard to make modifications to code or database design especially if you don’t know anything about the business process.
In sql server 2005 (or 2008) you can use sp_depends stored procedure to obtain dependency between the objects such as table, view or stored procedure.
For example just run ‘sp_depends Users’ script to determine which views or storep porcedures are using this table.
If you use this stored procedure with views or stored procedures it can show you the objects used in it and objects uses it.
More Information: sp_depends (Transact-SQL)
Happy codding…
