|
Home > Archive > MS SQL Server > August 2005 > Object Dependency Restoration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Object Dependency Restoration
|
|
|
| Does anyone have a simple script, or complex, that will help to define
dependencies of objects?
Over the years we have had stored procedures that depend on other stored
procedures and views that depend on other views. During deployment rather
than an Alter being executed a drop and create was done. We now cannot
depend on sysdepends to know linking. Before we go about creating our own
application to fix the problem I was interested to see if something already
existed.
The idea for fixing it is to reparse all objects then build a build order
based on what is in each object.
| |
| William Wang[MSFT] 2005-08-30, 3:23 am |
| Hi Andy,
I've have seen a seen a sample code which provides a solid solution for the
dependency issue. Indeed some users have tried to write their own code to
generate the sql script, you may want to take a look at this article:
Script Views by Dependancy
http://www.eggheadcafe.com/PrintSea....asp?LINKID=533
Additionally, it seems that Red Gate's SQL Compare and SQL Packager have
addressed this issue. You may want to refer to this article for more
information:
http://www.codeproject.com/showcase..._sysdepends.asp
Third-Party Link Disclaimer
===========
This response contains a reference to a third-party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
| |
| William Wang[MSFT] 2005-08-30, 3:23 am |
| Hi Andy,
I've just found that this article may also help.
http://databasejournal.com/features...cle.php/3501361
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|