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