The script will provide the list of all programmable DB objects and the objects being refered.
The objective of the script is to have a map of your database dependencies in the form of view for debugging and analysis purpose.
The known limitation all such methods is that we cannot dig in to map dependencies where dynamic queries are used.
CREATE view [dbobject_dependency_mapping]
as
select
referencing.*,
referenced.child_dbobject_id,
referenced.child_dbbobject_schema,
referenced.child_dbobject,
referenced.child_dbobject_type
from
(
select
[object_id] [dbobject_id],
schema_name([schema_id]) [dbobject_schema],
name [dbobject],
type_desc [dbobject_type]
from sys.objects
where [type] not in ('D','IT','PK','SQ','UQ','U','S','TR')
) referencing
left outer join
(
select
id [parent_dbobject_id],
depid [child_dbobject_id],
schema_name([schema_id]) [child_dbbobject_schema],
name [child_dbobject],
type_desc [child_dbobject_type]
from sysdepends
join sys.objects
on [object_id] = depid
group by id,depid,[schema_id],name,type_desc
) referenced
on referencing.dbobject_id = referenced.parent_dbobject_id 
A CLR Procedure that performs multi-threaded fie copies without external command line tools.
2013-11-19
3,113 reads
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-08
4,918 reads
The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...
2009-09-03
1,698 reads
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-13
38,455 reads
Is there a way to identify which objects are dependent on other objects within a SQL Server database? I need to modify the table structure to add new columns. However, before making any changes I want to make sure that I understand all the object dependencies. Is there a way in SQL Server 2008 to quickly identify all the object dependencies?
2009-06-26
3,798 reads