December 8, 2010 at 7:59 am
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
December 8, 2010 at 8:39 am
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.
December 17, 2010 at 3:59 am
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.
December 17, 2010 at 8:30 am
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