Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

find all the objects in a stored procedure Expand / Collapse
Author
Message
Posted Wednesday, December 08, 2010 7:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, December 18, 2011 11:29 AM
Points: 13, Visits: 26
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
Post #1031910
Posted Wednesday, December 08, 2010 8:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:29 PM
Points: 32,819, Visits: 14,965
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1031932
Posted Friday, December 17, 2010 3:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, December 18, 2011 11:29 AM
Points: 13, Visits: 26
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.

Post #1036440
Posted Friday, December 17, 2010 8:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:29 PM
Points: 32,819, Visits: 14,965
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1036570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse