find all the objects in a stored procedure

  • I have a question to find out all the objects used in a stored procedure.

    i can find it using sysobjects and sysdepends table. but it gives me only that objects which exist in

    same database in which procedure exist.

    how can I find all the objects in a stored procdure if, objects used in procedure are related to

    other database and procedure exist in other database. for eg i have a procedure in 'A' database

    and it is using table which exist in 'B' database. I m Working in sql 2000. if possible please give me solution in sql 2000 else in sql 2005

  • There is no good way to do this as the dependency tree takes some effort to build. Red Gate has a dependency tool (my employer) that will find the dependencies.

  • thanks for your reply.

    I have another question

    On one server there four instance of sql 2008 we need to upgrade it to 2008 r2. we will use inplace upgrade to upgrade on instance at a time.

    Please let us know what do we need to take care of and what will be the rollback plan.

  • That's a huge question. What do you need to do?

    Practice the upgrade on other servers, learn what might be a problem in your environment and document the process. Make sure you have good backups.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply